Hi,
I have a table with a few columns : Month, Amount Direct, Budget and Amount All and DS (cfr attach).
I want in my SAS VA dashboard a bar chart with Month as Category variable and Amount and Budget as measures. So far so good.
Below the bar chart, I want to see the column DS per Month as shown in the attachment.
What I need is a horizontal display of a list table but that does not exist.
Alternatively, I tried with a crosstab but I never succeed in showing only the values. I don't want to see the lines between row and column headers, etc ...
I found a solution by defining a list table per month (with filter on it) but that is not a good solution. We have a lot of similar KPI's so once you want to change an option, you have to do it for all tables seperately (same with filter on month).
How to deal with this issue ?
If I use a calculated measure with value = 0, then I get 0 as well as data label instead of the percentage in my DS column, no ?
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.