topic Re: Month Measure Segmentation in SAS Visual Analytics

Month Measure Segmentation

lo88lo — Wed, 16 Sep 2015 09:13:54 GMT

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

Re: Month Measure Segmentation

roy_walter — Wed, 16 Sep 2015 12:20:57 GMT

What does your source table look like?

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

Re: Month Measure Segmentation

lo88lo — Wed, 16 Sep 2015 14:45:03 GMT

I tried to explicate the problem in attached file

Thank you

Re: Month Measure Segmentation

Sam_SAS — Wed, 16 Sep 2015 16:38:13 GMT

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

Re: Month Measure Segmentation

lo88lo — Thu, 17 Sep 2015 09:43:08 GMT

Thank you very much but unfortunately not good

Re: Month Measure Segmentation

roy_walter — Tue, 22 Sep 2015 13:54:00 GMT

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

Re: Month Measure Segmentation

lo88lo — Thu, 24 Sep 2015 09:04:22 GMT

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

Lorenzo

Re: Month Measure Segmentation

roy_walter — Thu, 24 Sep 2015 10:44:53 GMT

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

This helps others pick out the messages easier.