topic Removing unnecessary sub totals? in App Development

Removing unnecessary sub totals?

AndyC — Mon, 03 Nov 2025 16:21:37 GMT

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.

Re: Removing unnecessary sub totals?

marcus_sommer — Tue, 04 Nov 2025 14:20:48 GMT

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.