I 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.
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 Labels | Count of BRSERTYP | Count of BKCLASS |
11 | 78,081 | 78,081 |
N | 35,242 | 35,242 |
NM | 25,553 | 25,553 |
OI | 10 | 10 |
SB | 4,894 | 4,894 |
SL | 150 | 150 |
SM | 12,232 | 12,232 |
12 | 4,005 | 4,005 |
N | 3,343 | 3,343 |
NM | 378 | 378 |
SB | 80 | 80 |
SL | 1 | 1 |
SM | 203 | 203 |
13 | 190 | 190 |
N | 25 | 25 |
NM | 74 | 74 |
SB | 41 | 41 |
SM | 50 | 50 |
21 | 270 | 270 |
N | 88 | 88 |
NM | 87 | 87 |
SB | 30 | 30 |
SM | 65 | 65 |
22 | 7 | 7 |
N | 1 | 1 |
NM | 5 | 5 |
SM | 1 | 1 |
23 | 1,830 | 1,830 |
N | 657 | 657 |
NM | 726 | 726 |
SB | 50 | 50 |
SM | 397 | 397 |
29 | 451 | 451 |
N | 203 | 203 |
NM | 143 | 143 |
SB | 39 | 39 |
SM | 66 | 66 |
30 | 211 | 211 |
N | 147 | 147 |
NM | 22 | 22 |
SB | 33 | 33 |
SM | 9 | 9 |
Grand Total | 85,045 | 85,045 |