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).
It might be possible of you use the graph designer and stack two graphs on each other. The top one as the one you attached and the bottom one with the DS.Use category as shared rule and format the bottom graph so that the bars are white so only the label is visible. Change the label color (usually the same as the bars). Create a calculated measure with value=0 so that the bars are minimized.
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.