Hi,
I am trying to create a graph which will have drill down as category and first level will be Year and i don't want to drill down to particular year i want drill down on all year at same time.
Year(2016,2017,2018)
-> Quarter(Q1,Q2,Q3,Q4 for all years 2016,2017,2018)
Hi!
I think the easiest is to create your own "drill-down".
First create a calculated dimension with the quarters (without year in the value, i.e q1,q2,q3,q4).
Then create a parameter that should contain the level (year, quarter, month....)
Create a calculated dimension that picks the level depending on the parameter:
If parameter = 'Year' then variableYear
else if parameter = 'Quarter' then variableQuarter
else if parameter = 'Month' then variableMonth
else ''
Add this new dimension to your graphs and tables and also add a drop down or button bar to enable the users to select level.
Add the parameter to the drop down or button bar.
For the different values (year, quarter, month) i use a small separate selection table, but you can also create a calculated dimension from another dimension and create the levels som that dimentions:
if dimensionVariable = 1 then 'Year'
else if dimensionVariable = 2 then 'Quarter'
else 'Month'
Hope this can help you 🙂
//Fredrik
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.