Skip to Content
0
Former Member
Apr 20, 2009 at 09:57 PM

Drill down with two row expansions

12 Views

Hi,

I am expanding rows by two dimensions: ProfitCenter and Account.

I have it set so it expands like this:

ProfitCenter1 Account1

ProfitCenter1 Account2

ProfitCenter1 Account3

ProfitCenter2 Account1

ProfitCenter2 Account2

ProfitCenter2 Account3

I want to drill down on ProfitCenter1 and get its children, and for each child, I want to have Account1,2,3.

ProfitCenter1 Account1

ProfitCenter1 Account2

ProfitCenter1 Account3

ProfitCenter1.1 Account1

ProfitCenter1.1 Account2

ProfitCenter1.1 Account3

ProfitCenter1.2 Account1

ProfitCenter1.2 Account2

ProfitCenter1.2 Account3

ProfitCenter2 Account1

ProfitCenter2 Account2

ProfitCenter2 Account3

Is this possible to do it through DrillDown? I would like to avoid 'Insert Members' if possible.

Thanks very much,

Michelle