Vizlib Home Try Vizlib

Pivot Table: Option to hide single-line subtotals

 Perhaps a tad optimistic of me, but: it would be nice if there was an option, in Pivot tables, to hide subtotals that only total a single line. In most situations, this will simply be a repetition of the line and only makes the pivot table more cluttered and harder to read.

Consider the below example lifted from Excel: the subtotal for "Fruit" isn't necessary as it simply repeats the line directly below it. Since there are cases where you might still want the subtotal (either to keep formatting consistent, or because you are using Dimensionality() in your subtotals and they aren't identical to the lines), this would likely be a toggle rather than a default.

Image result for Pivot table subtotal

1 person likes this idea
Login to post a comment