I'm struggling with a simple task. Having one category (year/month) and two measures, I want to create a report with year/month in the columns and the two measures in the rows.
Default the list table object looks like this:
2017-jan 10 20
2017-feb 15 10
2017-mar 11 12
The requirement is to swap the rows and columns to get this result:
2017-jan 2017-feb 2017-mar 2017-...
Measure1 10 15 11
Measure2 20 10 12
I have already looked into crosstab but it doesn't seem to give the required result.
I'm using SAS Visual Analytics 7.3.
You are not the first to struggle with this issue, but this cannot be done directly in VA Designer / Explorer 7.3, but it can be done in VA 8.2. See more at https://www.sas.com/va
If you want this, then you need to prepare your data before VA, just like the other answer suggested. Either in SAS og VA data builder.
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.