Average 90% Calculater in a pivot table

[mario-sarkis]

This my ROW data:

ID	Segment	Amount
1	Medium	1000
2	Small	300
3	Small	500
4	Medium	2000
5	Small	100
6	Small	200
7	Medium	500
8	Small	600
9	Medium	3000
10	Medium	2500
11	small	50

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 )

ID	Segment	Amount	Total Nb of IDs	90% of 5	Avg Amount
7	Medium	500	5	4.5	1500
1	Medium	1000
4	Medium	2000
10	Medium	2500
9	Medium	3000

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 )

ID	Segment	Amount	Total Nb of IDs	90% of 5	Avg Amount
11	small	50	6	5.4	230
5	Small	100
6	Small	200
2	Small	300
3	Small	500
8	Small	600

Final Output:

Output:	Avg 90%	Median	Avg	Min	Max
Medium	1500	2000	1800	500	3000
Small	230	250	291.6666667	50	600

gwassenaar  , dreamer4 qlikviewwizard  you can help

[mario-sarkis]

sunindia

[sunny_talwar]

Did you look at my response to your previous post?

[mario-sarkis]

yes just saw it sunindia thank you so much

[sunny_talwar]

no problem

I hope this is what you were looking for.

Best,

Sunny