• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table - Running total for Grand total line

I have a Pivot table for a range of weeks. For each week, I have Hours and Cost, e.g. for 01.02.2015 I have a column heading 01.02.2015 with Hours underneath. The next column heading is also 01.02.2015, but this time with Cost underneath.

Then the next column is a pair of 01.09.2015 columns with Hours and Cost, etc.

I have a grand total line that sums the Hours and Cost for each column.

I would like to add a second Grand Total line that calculates a running total for every column (Hours and Cost). I did a right click on the Grand Total line under the first column for Hours, then selected Value Field Settings, then selected the Show Values As tab and selected "Show values as," then I selected the Hours field. When I did this, all the values in the Hours column turned into #N/A, so this didn't work.

Is it possible to show a 2nd Grand Total line displaying a running total for each column?
 
Back
Top