Adding, removing, and positioning subtotals and grand totals

Excel PivotTables display your data in as much or as little details you prefer.…Pivoting and filtering the PivotTable changes how the individual data elements…are displayed, but you can also position the subtotals and grand totals for rows…and columns to summarize your data as desired.…For example, in this PivotTable I currently have both Subtotals and Grand…Totals turned on so you'll see that for FirmA the subtotal for the year 2009…was 963, for FirmB the same subtotal for that year was 924, and we have a grand…total for that year of 1887, and you'll see a subtotal for each of the firms…and the grand total for 2010.…

And then at the bottom of the PivotTable, which I displayed by scrolling down…using my mouse's scroll wheel, you'll see that we have a grand total for FirmA of…1924, FirmB of 1729, and a grand total for both of 3683.…Now, I'd like to show you how to change how subtotals and grand totals are…displayed, so I'll scroll back up so you can see my change more clearly.…Now after clicking any cell inside the PivotTable I can go up to the Design…