COGNOiSe.com - The IBM Cognos Community

I have 3 measures in my column and a some products in my rows.Its a dimensional package.
                 Measure1 Measure2 Measure3
Product1     12              14               45
Product 2     15              26               20

Total               27             40             20 (Min Value in this column)

If I add a total summary on rows , I want to show the total for two measures and min value on one measure  as shown above.

I tried to use a data item for measure3 and add the measure in the expression and then changed the aggregate function to minimum,but it dint work.I also tried to set the solve order but dint work.


Thanks,

I changed the aggregation method on total item to aggregation instead of Total and it worked .

Thanks,