Hi All,
Is it possible to calculate the median between the columns instead of rows in cognos? In my report user can dynamically select the measures based on the prompt and they want the median out of selected metrics.
In the below example I want to get the median of that row as 200(In my case user can select any combination out of 30 columns).
col1 | met1 | met2 | met3 |
abc | 100 | 300 | 200 |
Is it possible?
Thanks,
mc