Average 90% Calculater in a pivot table

mario-sarkis — Tue, 25 Aug 2015 12:48:58 GMT

This my ROW data:

Detailed Calulation of the Average 90% Requested :

The Average Amount "1500" is calculated as (500+1000+2000+2500)/4=1500 (4 denomimator is the 90% of total nb of client wich is 5 )

The Average Amount "1500" is calculated as (50+100+200+300+500)/5=230 (5 denomimator is the 90% of total nb of client wich is6 )

Final Output:

Re: Average 90% Calculater in a pivot table

mario-sarkis — Tue, 25 Aug 2015 14:25:46 GMT

sunny_talwar — Tue, 25 Aug 2015 14:27:52 GMT

Did you look at my response to your previous post?

mario-sarkis — Tue, 25 Aug 2015 14:30:40 GMT

yes just saw it sunindia thank you so much

sunny_talwar — Tue, 25 Aug 2015 14:32:35 GMT

no problem

I hope this is what you were looking for.

Best,

Sunny