Median from multiple columns

[mrcool]

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