I have a pivottable set up to provide our accountant with a WIP (work in process) printout with the fields he needs. He loves the report except for one thing...
All of the columns are dollar values, except for one, which is the %Profit field (Estimated Profit/Price). When I create the subtotals for each division grouping, all looks good except for this one column which adds all of the percentages up and displays this nonsense value. I would really just like to see a calculation in each of the subtotals of %ProfitTotal (Sum of Estimated Profit/Sum of Price). Is it even possible? If not, how do others handle this kind of problem? Do you just avoid pivottables that mix data types? Any other suggestions?
Thanks so much!
All of the columns are dollar values, except for one, which is the %Profit field (Estimated Profit/Price). When I create the subtotals for each division grouping, all looks good except for this one column which adds all of the percentages up and displays this nonsense value. I would really just like to see a calculation in each of the subtotals of %ProfitTotal (Sum of Estimated Profit/Sum of Price). Is it even possible? If not, how do others handle this kind of problem? Do you just avoid pivottables that mix data types? Any other suggestions?
Thanks so much!
