For the monthly subtotals, the figure is to be computed as Average Selling price for every year is to be computed as as Net Amount/(Ttl Bonus + Quantity). The Grand total column should be a a summation of individual subtotals.Ģ. For the monthly subtotals, the Net Amount and Bonus figure are to computed as a difference of 20 i.e. SUM of quantity of 2005 – SUM of quantity of 2006. The actual requirement is to customise the Subtotal column of the Pivot Table as follows:ġ. There is no complication in creating the Pivot Table described above. and the summarization function applied to them is SUM. In the Value area section are fields such as Net Amount, Quantity, Bonus etc. For some months, there is data for two years only 20. In the Column labels are two fields, Month and then Year – so in the column labels, for every month, there is data for three years 2005, 20. See workarounds for showing a grand total at the top or at the left, and other grand total tricks.Visualise a Pivot Table with a few Fields dragged in the Report filter, Row labels and Value Area section. In the pivot table shown below, I was able to change the Row “Grand Total” heading, without any problems.įor more information, go to the pivot table Grand Totals page on my Contextures website. You can’t change the “Total Field” headings, but you CAN still edit the “Grand Total” heading in that pivot table. However, that error message is a bit misleading. If you try to edit a Total Field heading, an error message will appear: “Cannot edit subtotal, block total, or grand total names.” It was easy to change the original “Grand Total” headings, but Excel won’t let you change these “Total Field” headings The Row Grand Total, in cell A11, did not change. Now, instead of a Grand Total column at the right, there are columns with “Total” and the field names – Total Qty and Total Orders In the screen shot below, the Order Count field was added to the Values area. If there are multiple Value fields in a pivot table, Excel shows a different set of grand total headings. In the screen shot below, I typed “GT” in cell D4, to create a smaller heading in column D.Īs soon you complete the name change, Excel automatically changes the other Grand Total heading, to the same text. NOTE: You can’t double-click the cell to edit the text.