#1
|
|||
|
|||
pivot table subtotal questions
Pivot table is-
Column Labels AA BB CC DD EE Grand Total Sum of Field B 11 26 30 39 48 154 How do I get sub total in column after CC that shows Subtotal ( AA+BB+CC)? Need help Source data in Excel Field A Field B AA 1 AA 1 AA 1 AA 2 AA 3 BB 4 BB 5 BB 6 BB 7 CC 8 CC 9 CC 10 DD 11 DD 12 DD 13 EE 14 EE 15 EE 16 EE 17 Last edited by sarana; 01-24-2019 at 05:56 AM. Reason: Adding excel file |
#2
|
||||
|
||||
Hi and welcome
please post a sample sheet ( no pics please) You can try the "Group" option in the PT menu after selecting the row fields you want (see Grouping Text Items at https://www.contextures.com/xlPivot07.html)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
You have total for whole pivot table at bottom - do you?
Add filter by label column. Set filter to display label AA, BB and CC (or whatever else). Overall Total is Total for those 3 labels. |
#4
|
|||
|
|||
Thank you. I have uploaded the file
|
#5
|
|||
|
|||
When I try to group it, it grouped other calculated field also
|
#6
|
|||
|
|||
As you can't have same field for filter and for group, I had to add a copy of Field1.
|
#7
|
|||
|
|||
Thank you!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Switch slicer report connections between pivot table and table | tyjulianchen | Excel | 0 | 02-28-2017 04:54 AM |
Create PIVOT chart using few rows in pivot table | Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
Pivot Tables - Values divided by Subtotal | Loretti | Excel | 0 | 11-12-2012 02:15 PM |
Each subtotal signature require only at last page for each subtotal. | aligahk06 | Excel | 0 | 05-07-2010 11:07 PM |