If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

RESOLVE -- Median involve in subtotal-total --

Started by jive, 01 Nov 2010 07:50:12 AM

Previous topic - Next topic

jive

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