Removing unnecessary sub totals?

[AndyC]

This is something that crops up regularly.

I have a pivot that has row totals set-up. But a lot of the Dimensions result in a single row. No real need to show the subtotal here. Has anyone got an idea of how to do this?

E.g.

Customer B21I shows only one row of detail so a subtotal is superfluous. It would save space and improve readability if it was omitted.

Customer B22 has multiple rows so showing a sub total makes sense.

[marcus_sommer]

You may query dimensionality() + secondarydimensionality() and/or further expression-results to return a ZERO or NULL which could be hidden within the chart-properties, maybe like:

if(match(dimensionality(), 0, 2, 4), null(), MyExpression)

Just add dimensionality() + secondarydimensionality() as separate expressions to see their results and then you could start playing.