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 ?
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.