how to display 2 measures of different aggregates dynamically (drill across solution)

[jplarios]

Hello:

I am trying to see if there is a drill-across solution in VA like below:

lets say one object table is showing the head of Dept A , the instructors under Dept A, in particular Joe below, hist course and the  campus and the measure:

Dept	Instructor	course	campus	measure1
A	Joe	Math	SE	20%

now I want the head of Dept A to drill across for that faculty, joe and compare the measure for math but for all dept. and campus:

Dept	instructors	course	campus	measure1
All	All	Math	collegewide	34%

What would be the options for the above drill across in VA.

[PetriRoine]

Hello @jplarios 

Could you please provide a little bit more information to help understand the need.

- A sample data set?

- Which version of VA you have?

- Maybe some kind of sketch of the report page and how you want it to work?

Best regards,

Petri

[FredrikE]

Hi!

Hope I understand your problem correct 🙂

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 🙂

//Fredrik