Pivot table - subtotal at top of column

L

Laurence Lombard

I have a straightforward pivot table like


Sum of NETT
CODE
98 -2029.94
110 -179986.51
120 -101994.54
Grand Total -5.42
I reference the subtotal from elsewhere in the workbook, therefore do not
want the position of the Total to change when the pivot table is updated.
Excel help discusses "Subtotals on top of columns" and describes indented
format and non-indented format but as far as I can ascertain this does not
apply to this case.

My solution at this stage is to remove the Grand total (via Pivot Table
options) and to put a Sum function above the column that extends well below
the pivot table eg =SUM(B2:B10000). This is not the most elegant way. Is
there a better way?
Thanks
Laurence
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table grand total location 1
Average of Subtotals in Pivot Table 0
Pivot Table - 3
Pivot Table Count 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
% of subtotal in pivot table 1
Subtotal/Consolidate/Pivot Table, Lookup ??? 2
Pivot Table Calculates the Difference in Grand Total 2

Top