Calculated Fields in Pivot Tables

[verramilli]

1. I have added a field to a pivot table and the calculation is an Average of the field

2. I added the same field to a pivot table again and the calculation is a stdev of the field

3. These two fields are NOT calculated fields but the same field added as a different summarization

I need to add a calculated field as second field/first field (stdev of field/average of field)

Is there a way to do this? I don't have fields one and two as fields to be used in the calculated fields.

[dilipandey]

Hi verramilli.....

Welcome to the forum.

Suggest you to upload the sample file... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[verramilli]

File attached. I am looking to put ratio of Average to Stdev as an entry in the pivot table.

[dilipandey]

Hi verramilli,

After downloading, when I am trying to open the excel file I am getting following message:-

either the file extension is not valid OR the file is corrupted

Please check?

Regards,
DILIPandey

<click on below 'star' if this helps>

[verramilli]

Re attaching file.Sample_Datq.xlsx

[dilipandey]

Hi Verramilli,

Since both of the columns i.e., Average of Qty2 and StdDevp of Qty3 are derived from a single field "Qty" hence adding a third as division of both is not feasible. I would suggest to use a separate column towards right of pivot which will divide column c by column d and formula can be dragged down (adjusted) using a macro. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>