I have a pivot table which I have set to show cumulative figures (running total in). I am then inserting a calculated field to show an additional column on the end of the pivot. However the sum in the calculated field is using the original figure in the pivot and not the cumulative figure (running total figure) I have put on the columns in the pivot, therefore the calculated field column has incorrect figures in.
How do I get the calculated field to use the cumulative totals for each field?
Bookmarks