Insert calculated field into pivot

[thesilkster]

Hi i am trying to insert a simple calculated field

i have a count of products and a sum of products i want to find the avg

both update qty are from the same field

thanks if you can help

 

[Chihiro]

You can't do calculation on PivotTable columns. The calculation is based on data source columns.

If you have each Update_Qty as distinct row, you can just do Avg. column and you will get the result. If there are some aggregate rows, you need helper column for count and divide Update_Qty by that column.