Exclude Row from "Show Totals" field in pivot table

[aknabe1]

I am using "show total" field to calculate YTD values for 12 measures. Is it possible to hide the total from 2 of these measures and keep the rest of the totals? 

For example, I would like to not calculate, or hide the 15.49 total (first row), but keep the remaining total rows 194.91, 99.82, 0.10, etc...

If there is a better way to incorporate YTD values in a pivot I am open to ideas...

[stevejoyce · Accepted solution]

You can try like this as your measure fx...

SecondaryDimensionality()=0 is your total column

I'm giving example your row dimension is called Dim1 with values of A, B, C, D, etc. 

Update to your dimension name, dim value, expression:

If(SecondaryDimensionality()=0 and Dim1='A', null(), sum(Value))