ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table - Grand Total for selected columns only (https://www.excelbanter.com/excel-discussion-misc-queries/138974-pivot-table-grand-total-selected-columns-only.html)

KG

Pivot Table - Grand Total for selected columns only
 
I have a Pivot Table showing data for three years:

Product names as rows
Product Volumes, Prices and Sales Value as 3 columns x 3 years

I do want the grand total of the Sales Value columns but not of volumes and
prices, because those numbers are totally meaningless. Can I limit the grand
total to selected columns only?


All times are GMT +1. The time now is 05:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com