Excel 2010 Pivot Tables Calculated Fields Subtotals

[elderjason]

I learned much today about calculated fields and subtotals in pivot tables. There is much I still need to learn. Here is my sample data and pivot table. I have a calculated field that divides the sum of fields. The pivot table will summarize this field in the grand total and when I collapse the row. It will not summarize when I expand the row. According to my research, it is not possible for this calculation to summarize. I'd really appreciate some insight into this. Thank you in advance. Jason