Thread: pivot table subtotal questions
View Single Post
 
Old 01-23-2019, 09:26 PM
sarana sarana is offline Windows 10 Office 2010
Novice
  
Join Date: Jan 2019
Posts: 6
sarana is on a distinguished road
Default 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
Attached Files
File Type: xlsx BookA.xlsx (14.8 KB, 9 views)
Last edited by sarana; 01-24-2019 at 05:56 AM. Reason: Adding excel file
Reply With Quote