Month Measure Segmentation

[lo88lo]

Hi,

I Have this problem with SAS Visual Analytics 7.2 in a crosstab

Situation:

Category	Group		Month	January	January	February	February
Category	Month		Group	Contact	Sell	Contact	Sell
Measure	Contact		Group1	10	4	7	2
Measure	Sell		Group2	15	5	8	3

Situation Desired

Category	Group		Month	Contact	Contact	Sell	Sell
Category	Month		Group	January	February	January	February
Measure	Contact		Group1	10	7	4	2
Measure	Sell		Group2	15	8	5	3

[roy_walter]

What does your source table look like?

Would it be sufficient to remove group as column and re-add it above the period?

[lo88lo]

I tried to explicate the problem in attached file

Thank you

[Sam_SAS]

Hello,

It looks like you want the columns in a crosstab to be grouped by the measures rather than the categories. I don't think this is possible.

If you move MONTH to the row axis (no category assigned to the column axis), the result might be closer to what you want.

Another possibility might be to create a separate crosstab for each measure.

I hope that helps,

Sam

[lo88lo]

Thank you very much but unfortunately not good

[roy_walter]

I have to agree with Sam.

In a single cross-tab. This does not seem possible. It is required to use measurements on the lower part.

I will propably get yelled at for this, but you could split up your rows between sell and cross.

Columns:

- Category: Group

- Category: Month

- Category: Type (Contact/Sell)

- Measure: Value

With that you could create a crosstab that looks quite like you want it, but only has the 'value' as measure and the Month and Type as Columns.

I am very unsatisfied with such duck-tape solutions, but it depends on how bad you need it to actually look you stated.

Hope this helps push you into a somewhat acceptable solution.

Regards,

Roy

[lo88lo]

not exactly what I needed but still is a good idea
thanks a lot

Lorenzo

[roy_walter]

Could you mark answers as helpful or solved if you think that is what they are?

This helps others pick out the messages easier.