Hello,

Hoping someone can help...

I have a pivot table where a column returns the average of a list of percentages in my source data. All I need is to flip that percentage on its head. For example the average I get in the column is 28.4%, how do I get the next column to say 71.6%?

I know I could do it using the formula =1-average(cell range) but I'd like to be able to do it in the pivot table to keep things slick. Can it be done? Feels simple but I cant figure it out.

Thanks.