How to use drill down dimension in measure as calculations

[Sagar082]

Hi folks,

Greeting for the day. I always have some new challenges.

Now, I'm looking something like; the use of drill down dimension to calculation measure.

For e.g. I'm creating 100% stack chart. In which the calculations is based on dimension. 

At initinal stage it should be;

Measure/dimension(var1)

When user drill down then it should alter to;

Measure/dimension(var2)

I achieve this by using variable input. But, could not achieve in drill down.

Thanking you in anticipation.

Regards,

Sugar.

[Anil_Babu_Samineni]

If you are using measure what you showed in dimension you have to aggregate? hope you have flexible in your current version to do dynamic dimension drill down?

[Sagar082]

Hi,

Can you give me example? I'm looking for solution at chart point of view not at scripting level

[Anil_Babu_Samineni]

Sure, Please provide sample data set.