I have a table with Company, Item, Year, Percent, and Sales. I have a
calculated field in a Pivot table called PercentSales (= Percent * Sales).
The problem I'm having is the subtotal by Item is totaling PercentSales as
Sum of Sales * Sum of Percent. How do I get the subtotal by Item of the
PercentSales field to be either (Sum of Sales * Percent) or Sum of
PercentSales (and not Sum of Sales * Sum of Percent)? Thanks.