Hiding dimension value in pivot table, but still be able to use this value for total display.

[retko1985]

Hi,

I am not sure if description is clear, so here is the example, see attachment please.

A have a data set like this:

Notice the last row, where level2 is NA - this is actually a total for Level1.

Same is with NA in Level3 - these are the totals for given dimension value in Level2

Now I want to use this as a total in pivot table, but hide it from rows:

I want to hide what is marked in red.

Can someone help me with this please?

Thank you very much!

[sunny_talwar]

Awesome