Drill down with two row expansions

20 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