09-16-2015 05:13 AM
I Have this problem with SAS Visual Analytics 7.2 in a crosstab
09-16-2015 12:38 PM
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,
09-22-2015 09:54 AM
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.
- 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.