BookmarkSubscribeRSS Feed
Quartz | Level 8

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

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.

2 REPLIES 2
Pyrite | Level 9

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

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

Rhodochrosite | Level 12

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

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

Discussion stats
• 2 replies
• 496 views
• 0 likes
• 3 in conversation