Analysis for office - Show Level

[former_member1224587]

hierarchy.jpgHello

Is it possible to de-select last node from the hierarchy using show level and deselect the last node? Many thanks - Piyush

[former_member269156]

Hi,

I think its by design.

Select a member cell of the dimension in the crosstab and choose Hierarchy Show Level... . Select the levels that should be available in the analysis and press OK. Only the selected levels can be displayed in the crosstab. The total is not affected by this selection because the leaf level is always available.

Thanks,

Raju