Pivot Table - different measure for each dimension/row

[mhassinger]

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)
        

[Lisa_P · Accepted solution]

You can use the Dimensionality() function.

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

[mhassinger]

Perfect, thank you!