DashboardNovice
Member
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?
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?