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
