My apologies, I can’t really show you what I’ve bcuz it has sensitive info and pretty confidential. I use 8.5.2 version of sas viya. Yes I created those subtotals and it is confusing but how I did will let you know. In page2, I used some of the crosstabs to show it as a pivot tables for the viewers. In those crosstabs I used a column named X which is a character as a row in ROLES and in the Roles for measure I used another column named Y which is a numeric. For each individual crosstab I used these two and added some filters for each one to get required subtotals as I’d wanted to see. All these subtotals in the crosstabs of page2 should be shown as totals in the crosstabs of page1 for that, I created some new columns those are the totals of these subtotals cuz they can’t be done in Viya right?. So, I created them along with the data table I use for this dashboard. Basically my dashboard should be like an excel which has some pivot tables for each tab and when I click the cell in the summary tab of an excel file, it’ll highlight some cells from where that count came from so, this has to be replicated in sas viya so that the viewers can drill down the data if possible. And, Likewise if i start digging in it’ll take me to the last page which has list data. I hope this is clear to you.
... View more
