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.