1 Reply Latest reply: Apr 10, 2017 4:41 AM by Nicolò Cogno

# Pivot table values with deviation from the average

Hi everybody,

I've got a pivot table where every line contains an object. Objects are divided in categories and I use the pivot in order to show how the objects are divided between categories. I want to know how much does every object price deviate from the average value (so, for example, imagine I have a fruit with a code, it can be put both in the pears set, but also in the fruits set and so I would like to know how much does its price deviate from the average price of the pears and of the fruits), but when I try to calculate it I get only a value for the set, and not a value for every line. I also tried with set analysis, but I can't figure out how to do so.

Best regards

Nicolò Cogno

• ###### Re: Pivot table values with deviation from the average

Hi everybody,

I solved the problem with this expression, hope this will be helpful:

avg( total < [Pears], [Fruits] > [Price] )