80th Percentile calculation

[krish2459]

Hi,

I need to calculate 80th percentile for the count of sales orders for each month.

Attached is the sample data.

Thanks..

[ramasaisaksoft · Accepted solution]

Hi Krish,

what is the result you need in that excel file?

=Aggr(count distinct(Sales Order),month)

[Frank_Hartmann]

are you looking for this?