I have a PT that is doing a sum of orders and sales for a given year. Also in there is the number of return orders that occurred in that year.
How can I create a calculated field to see the percentage of orders where a return occurred? When I try to do it within the actual PT in the spreadsheet the fields always show as GETPIVOTDATA when having the formula reference them and always return a zero. Trying to do it as a calculated field to be in the PT field list I don't see a way of doing the summations that occurring within the PT that I'm then wanting to using my calculations to be based off of.
Is there a way around this?
How can I create a calculated field to see the percentage of orders where a return occurred? When I try to do it within the actual PT in the spreadsheet the fields always show as GETPIVOTDATA when having the formula reference them and always return a zero. Trying to do it as a calculated field to be in the PT field list I don't see a way of doing the summations that occurring within the PT that I'm then wanting to using my calculations to be based off of.
Is there a way around this?