Member addition.

[Former Member]

I have a dynamic reports where 2 cost center hierarchies in 2 columns and 3rd column is total of first 2 columns. Is there anyway I can hide these 2 columns and still achieve drilldown from 3rd column, which is local member. Appreciate inputs..

[former_member190501 · Accepted solution]

Hi,

Expansion on local member ? I don't think its possible.  Requirement looks bit strange. Both the hierarchies may not be the same level of nodes. How can you expand.

Thanks,

Raju

[Former Member]

Hi,

Maybe you can make hierarchy for those two cost center, with that you can achieve the result you want it.

Or  you can had 1 dimension in row axis which is had the same member for those 2 cost center.

With this action, you can had drill down , but at the row axis.

Hope it helps.

Thanks,

Suprapto