Pivot / Straight Table - Only show a dimension if it has a value

[#1]

Hello,

Does anyone know of a way of only displaying a dimension if it has a value?

I have an 8 level hiererchy that people use to browse differenct areas of the business, but not everywhere uses all 8 levels. For example, above the hierarchy only runs to level 3, the rest of the levels are null.

I want the pivot table i have to display the subsequent levels only if there are values to show, if the levels are NULL I want them hiding. Is this possible? I'm guessing some kind of expression in the show column section of a straight table, but can't see an equivalent condition for a pivot table?

Many Thanks,

Matt

[#2]

You can't conditionally show fields using a PT like you can with a straight table.

Have you thought of using a calculated dimension, something like:

if(isnull(Level), Null(), Level) and then tick "Suppress when value is null" on the dimension tab? Maybe ticking this option will work on your PT without the need for a calculated dimension so try that first.