Macro Subtotals

whynot

Board Regular
Joined
Jun 27, 2009
Messages
111
Office Version
  1. 365
Platform
  1. Windows
would like to subtotal of data in two rows in a pivot table. Is that possible.

The illustration below is my pivot table.

I would like have a subtotal for 11 and 12.

Thank you very much for the help.


Row LabelsCount of BRSERTYPCount of BKCLASS
1178,08178,081
N35,24235,242
NM25,55325,553
OI1010
SB4,8944,894
SL150150
SM12,23212,232
124,0054,005
N3,3433,343
NM378378
SB8080
SL11
SM203203
13190190
N2525
NM7474
SB4141
SM5050
21270270
N8888
NM8787
SB3030
SM6565
2277
N11
NM55
SM11
231,8301,830
N657657
NM726726
SB5050
SM397397
29451451
N203203
NM143143
SB3939
SM6666
30211211
N147147
NM2222
SB3333
SM99
Grand Total85,04585,045
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top