Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
try this:
median(aggr(count([Sales Order]),FSD))
or this:
aggr(median(aggr(count([Sales Order]),FSD)),Month)
try this:
median(aggr(count([Sales Order]),FSD))
or this:
aggr(median(aggr(count([Sales Order]),FSD)),Month)