excel - Pivot table custom sub total -

Is there a way to create a row in any type of line in which the row contains the subtotal of a specific subset of the label? For example if I had a line label with the source name that contained the following values: A, B, G, H, #,?. Can I make a line which is based on source A, B, G, H, but subtotals for various efforts made on the basis of not including numbers for #? In the following I have what I currently have and what I want to add to the bold section.

Source ----- Eff1 Mail ------ Eff2 Mailed - A ---- ----------- 10 ------- ------------- 10
B ------------- ---- - 5 -------------- -------- 4
G ------------- 148 ---- ---------------- 140
H ------------- 658 --------------- ----- 524
Total ----- 821 -------------------- 678
$ - ---------- 1247 --------- --------- 1056
-------------- 52 --------------------- 47

Yes, you have a calculated object that connects A + B + G + H, but clearly it is in your source data for those entries Adding a flag can be easy and add that flag as a line.

However, select a ROW item ( a ), pivotable tool> analysis> calculation - fields, items, & amp; Set, Calculated Item ..., Name: As You Want, Formula:

  = SUM (A + B + G + H)  

OK