Calculated Field in Pivot Table

[Jasmaine86]

Hi There,

I need a calculated field to work out the "completed on time" % in my pivot table.

When i do it manually, my formula is =(D5-B5)/D5.

I want to insert a calculated field but only have it create one extra column with one result.

Thank you,

 

[GlennUK]

So, isn't that =OnTime/(Failed+OnTime)

 

[Jasmaine86]

So, isn't that =OnTime/(Failed+OnTime

Hi Glen, i didnt work. I feel like i have entered it wrong.

 

[GlennUK]

Sorry, I was seeing that as 2 fields, not 2 items of the same field. Look at this ... it's more than one extra column, but does the right calculation (added Count to Data Area twice, and having the second one be Field Settings/Show Values As/% of Row Total):

 

[Jasmaine86]

Sorry, I was seeing that as 2 fields, not 2 items of the same field. Look at this ... it's more than one extra column, but does the right calculation (added Count to Data Area twice, and having the second one be Field Settings/Show Values As/% of Row Total):

Thanks Glen. This was helpful. I have played with this format before but was hoping there was a tidier way to transform the data and show the one result.

 

[GlennUK]

Thanks Glen. This was helpful. I have played with this format before but was hoping there was a tidier way to transform the data and show the one result.

Well, you could add 2 fields to your data, one for Fail and one for On Time, and then my initial suggestion would work:

 

[Jasmaine86]

Thanks Glen. I'll give it a whirl