Djblois
11-16-2009, 09:58 AM
I am trying to get the correct Profit % in pivot Tables but it is not working. Here are the issues:
1) If I do an Average of the % column (from the data tab) in a Pvt Table then I lose Weighted Average.
2) If I do a calculated field in a Pivot table With Profit/Amt then I am getting incorrect data when ever it is supposed to be negative (when amt and Profit are already negative they divide into a positive number) or when amt is equal to zero
I am trying to do an advanced Calculated field in Pivot Tables with IF statements but it will not let me. Does anyone have any ideas what I can do?
I have uploaded some sample data.
1) If I do an Average of the % column (from the data tab) in a Pvt Table then I lose Weighted Average.
2) If I do a calculated field in a Pivot table With Profit/Amt then I am getting incorrect data when ever it is supposed to be negative (when amt and Profit are already negative they divide into a positive number) or when amt is equal to zero
I am trying to do an advanced Calculated field in Pivot Tables with IF statements but it will not let me. Does anyone have any ideas what I can do?
I have uploaded some sample data.