hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
Afternoon kind folks.
I have a pivot table which I want to add a extra subtotal to.
The pivot table shows a list of Business Reports in rows then the columns show the percentage complete by how well its done good/bad/not started etc.
Currently I have to add an extra column on the worksheet to the right of the pivot table to show a "subtotal" of all completed reports which is basically the Grand Total %age, minus the Not Started %age.
Is there a way of adding this into the pivot itself, or is it just as easy to leave it to the right of the table and not actually part of it?
I have a pivot table which I want to add a extra subtotal to.
The pivot table shows a list of Business Reports in rows then the columns show the percentage complete by how well its done good/bad/not started etc.
Currently I have to add an extra column on the worksheet to the right of the pivot table to show a "subtotal" of all completed reports which is basically the Grand Total %age, minus the Not Started %age.
Is there a way of adding this into the pivot itself, or is it just as easy to leave it to the right of the table and not actually part of it?
