This is a similar application. I am trying to calculate median for group. My base fields are :
- total calls
- Cost per call
I need to sum these and find the median cost per call for the Centre (where we have upto 20 centres and anywhere from 5 to 20 call handlers per centre) ....
Hope this makes sense, i tried your Qlikview Solution - but getting null values in Sense....