Hide some expression totals in pivot table

[dukane24]

Hello,

I have a pivot table with three expressions, however I only want to show a total for one of them.  Is there a way to hide the ones I don't need? I know there is a "Show Partial Sums" option that can be turned on and off, however this is by dimension, not by expression.

Thank you!

[sergio0592]

And if you check Expression Total in Total Mode just for the expression you want display the total?

[dukane24]

Hello,

The total mode section is greyed out - I don't believe it's available for pivot tables.

- Thank you

[MarcoARaymundo · Accepted solution]

Use a dimensionality function.

If(dimensionality() = "Total row nimber", '', Sum(Field))

[dukane24]

Perfect! Thank you!