topic Re: Pivot Table: Set the value or don't show the value in specific dimensions in App Development

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

NathanS2022 — Wed, 18 Jan 2023 18:14:21 GMT

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?

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

pedrobergo — Thu, 19 Jan 2023 14:09:27 GMT

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

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

jbhappysocks — Thu, 19 Jan 2023 15:18:40 GMT

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.

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

NathanS2022 — Thu, 19 Jan 2023 17:03:36 GMT

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.