HI,
I have to build a short list report with 3 groups inside, age group ( 18 and more , lower then 18), sex, unit responsible (4 items here) and 6 meausure each meausre have the same granularity and come from the same fact table. Everything works fine for all of my calculation, I have 3 totals, 2 average, and one median. I don't know why but the median is the only one that didn't work. For each row the calculation is OK, for the first subtotal I modified the calculation like that median(nb_call for [age group]; [sex]) and for the first subtotal it's OK, but I can't have the median for the report or the other group. What is the way to do that kind of calculation.
It's a list, 3 group 2 subtotal and one total
Thanks