Pivot Table: Set the value or don't show the value in specific dimensions

[NathanS2022]

Hello, I have the following table:

I want the measures 5 and 6 to have a blank value or no value at all. Like this:

I've tried using TOTAL and AGGR functions and also using Flags on load, with no success so far. How can I do this?

[pedrobergo]

Hi @NathanS2022 

If you´re looking for not showing detailed values for Users, the only way is removing 5 and 6 fields from Pivot Table, because each level has a sum/total of below values.

[],

Pedro

[jbhappysocks · Accepted solution]

Hi I also don't really see why you want to keep 5 & 6 if you want to hide the value, you don't need it to get the totals. But if you have a good reason you can write

if(getobjectdimension(dimensionality()-1)<5,sum(VALUE),'')

If you only have a condition on dimensionality you users will be able to get around this by changing dimension order. And obviously you need to change the condition if your dimensions are not 1-6 but actual dimension names.

[NathanS2022]

Thank you very much! It worked exactly as I needed. Here's how I used the condition:

If(GetObjectDimension(4) = 'Name Of Index 4' AND Dimensionality()=5, ' ', Sum(VALUE))

This case works since the users don't change dimension orders because it would be pointless for them in this specific case and there's no problem in them seeing the value of 5 and 6. It's just for a cleaner visual.