Evaluate for Total Row in Pivot Table

[jackm75]

I'm looking to be able to identify the Total Row (Show Partial Sums) with an IF statement.  How can I do that?

Example:  IF(<Total Row>=True, Do This, Do That)

[swuehl · Accepted solution]

Have a look at Dimensionality() resp. Secondarydimensionality() functions in the Help file. Also search for 'examples of chart inter record functions' for a some samples.

[jackm75]

Thanks for pointing me in the right direction, swuehl.  With Dimensionality, I was able to achieve what I was after!