Median

[krish2459]

Hi,

I want to calculate the Median for the my count(sales orders ) over Month.

I tried 

median(aggr(count([Sales Order]),[Sales Order]))

but I'm getting only one as median for all months.

Attached is the sample data file.

Thanks..

[Frank_Hartmann · Accepted solution]

try this:

median(aggr(count([Sales Order]),FSD))

or this:

aggr(median(aggr(count([Sales Order]),FSD)),Month)