I have a table in Excel, and I've managed to create a pivot table, which includes "grouping".
What I'm trying to do, is sum the group
My pivot table data looks like
What I'd like to have is a sum for each 'group', where a group is each 2 rows, the parent being the town.
In otherwords, this is 1 group/row
Arrington School 12600 25
R 6946.2 22
What I'm trying to do is to sum the miles per year, and the time taken by group. So, something like (although where the summed data is displayed isn't too important)
Arrington School 12600 25
R 6946.2 22
19546.2 47
Where that new bottom row is the sum of the 2 value above. This would repeat for each group/row in the pivot table.
I don't seem to be able to achieve this because when I click on Field Settings in the Rows pane (after selecting the pivot table)... What do I need to do