How to disable the subtotals on pivot table

Feb 2, 2012 at 10:13 AM

By default , the generate pivot table shows sub totals on rows and columns. How do we disable them?

pivottable class has properties to enable/disable grand totals for rows and columns. I would like to disable the sub totals too.

(Note : Subtotals are only displayed when when there are two or more columns or rows in pivot table)