I have problem with subtotal in pivot table, you can see in attached file, vol (yellow column) has a formula and calculate volume variance by material family group.
Problem is, A Total (316), B Total (-570) and Grand Total (-158) dosent calculated correctly. I tried aggr and dimensionaliy but I couldnt calculate correct values.
correct values; A Total it must be (83), B Total must be (-628), grand total must be (-545)
