Trying to created a Calculated Field in a Pivot Table

[David_j78]

I have a pivot table that has two side-by-side columns that I have set to show the Min $ amount of their column in my data set. I want to created a calculated field in my pivot table that shows me a % difference between those 2 columns.

I first tried to use just =iferror(((Retail_Daily-Account_Dailyt)/Account_Daily),0), but this formula gave me the % difference of the sum total Retail Daily and Account Daily columns.
So then I tried =Iferror(((Min(Retail_Daily)-Min(Account_Daily))/Min(Account_Daily)),0), but still got the same return of the % difference as if my two columns were sum totals.

What am I missing?

 

[James006]

Hi,

To dive into the specifics, have a look at following link :

Excel Pivot Table Calculated Field vs Calculated Item

Compare Excel pivot table calculated field and calculated item. How they work, when to use, limits, warnings, examples. Step by step video, Excel workbooks

www.contextures.com

 

[David_j78]

Hi,

To dive into the specifics, have a look at following link :

Excel Pivot Table Calculated Field vs Calculated Item

Compare Excel pivot table calculated field and calculated item. How they work, when to use, limits, warnings, examples. Step by step video, Excel workbooks

www.contextures.com

I know how to create a calculated field.
My problem is, that I am trying to created a calculated field that takes the Min of my Retail Daily column and subtracts the Min of my Account Daily column.
But no matter how I write out my calculated field formula, it doesn't take the Min of those columns. It's returning a value based on the sum of those columns.