I Have this problem with SAS Visual Analytics 7.2 in a crosstab
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,
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.