Attached is a pivot table problem I am having:
If you look at the Grand Total field for "2011 Y/Y % Change", it is showing -100% change when it should be showing 0%. I think it is because it is trying to total that column, when I want it to compare C7 and E7. The product is 'discontinued' and should not be considered in the results (which is where the problem is occurring).
I'm open to suggestions, but would like to keep all calculations in a pivot table since the real data is very large and the pivot table filters are changed on the fly to display different products.
Bookmarks