DrillDown Group in diferent Alternate States

[Anonymous]

Hello!

I have 4 sheets on my document, each one with a different Alternate State (the first sheet gets the default state, and each one of the others got a different state).

I've created a Drill-down Group and I need to use it in chart on different alternate states, but It just works on the sheet with the default state.

How could I do to have this Drill-Down Group working on the other States?

Regards,

Gabriel

[morganaaron]

Hi Gabriel,

You'd do this inside the analysis done on each of the other sheets.

If you have a drill down group that is Country > City, and you want the selections in the default group to run through to the other charts, where you have the other charts you'll want to use set analysis on the expressions and include:

Sum({<Country=$::Country), City=$::City)>}Sales) for example. This will keep those two fields synchronised with the drill down group (in this case country and city) selections in the default state. As long as you have the same drill down group in each of the charts as the dimension, this should mimic the same behaviour.

[Anonymous]

Hello Aaron, thanks for your answer.

I've did that, and both got synchronized. But I need they independent, each one respecting his own alternate state. Even creating 2 Drill-Down Groups, both always will respect the default state. What I need is that this Drill-Down respect other alternate state, and not the default one.

Follow attached an example document. I need both drill-downs independent from each other.

Thanks,

Gabriel

[morganaaron · Accepted solution]

Then I think you're out of luck - there's no option to set an alternate state on a Drill Down group, so I'm afraid it wouldn't work.

The only other option is to add the fields contained within the drilldown into your dimensions on the second chart and use a GetSelectedCount() statement on both to sort of replicate the behaviour.

See attached for the example.

[Anonymous]

Thanks again, Aaron.

I've found that solution with GetSelectedCount() too, but I'd like to be sure that it can't be done with DrillDown Group. Looks like it can't be done, unfortunately.

Anyway, thanks for your help.

Gabriel

[kkkumar82]

Hi Gabriel,

we are also facing a similar kind of situation, i.e. when alternate states and drill down groups are used we are unable to drill down.

Did u had any solution which works when we have both of them.

Thanks & Regards

Kiran Kumar

[Anonymous]

Hello, Kiran

The only solution that I've found is the one that Aaron posted above, that uses GetSelectedCount() to simulate drilldown behaviour.

Regards,

Gabriel