I did a test using sashelp.class. You can try it yoursellf by importing sashelp.class into VA.
This is the outcome:
On the report there are 2 button bars and 1 cross-tab. All measures are set to average aggregation. I have created 2 new dimensions that are used in the cross-tab. I also created 2 dimension for the choices in the button bars.
I use the button bars to select level of detail for sex and name (using parameters). Depending on their values the drill level will change:
Then create a new report and add the data set.
Then create 2 new dimensions (*_dim, 2 new level choice (*_choice) and 2 paramters (*_level):
Set default value for the parameters to 'Sex' and 'Name'.
Define the sex_dim as:
Create name_dim as:
Create level choice as:
Add two button bars and assign them as:
Add a cross-tab and assign as:
Set all the measures to average aggregation and start testing 🙂
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.