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

Different Aggregattion on total summary value

Started by Manu0521, 01 May 2014 07:44:17 AM

Previous topic - Next topic

Manu0521

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,

Manu0521

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

Thanks,