Pivot Table - different measure for each dimension/row

mhassinger — Wed, 27 Jul 2022 02:40:00 GMT

Hello!

I have a pivot table with three dimensions. Some of the measures in the table are only relevant in the context of certain dimensions. So basically I want to be able to not calculate a measure (or calculate it differently) depending on the dimension/row.

So for example, in this pivot mock up I wouldn't want to see Sum(Sales) unless it's in a row that's for the city dimension. Obviously my real life use case is not as clean cut as a geo hierarchy.

+ Canada N/A
- USA N/A
+ NY N/A
- IL N/A
Chicago Sum(Sales)
Springfield Sum(Sales)

Re: Pivot Table - different measure for each dimension/row

Lisa_P — Wed, 27 Jul 2022 03:59:42 GMT

You can use the Dimensionality() function.

If(Dimensionality()=3, Sum(Sales), 'N/A')

Re: Pivot Table - different measure for each dimension/row

mhassinger — Wed, 27 Jul 2022 04:08:58 GMT

Perfect, thank you!

topic Re: Pivot Table - different measure for each dimension/row in App Development

Pivot Table - different measure for each dimension/row

Re: Pivot Table - different measure for each dimension/row

Re: Pivot Table - different measure for each dimension/row