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

Help with custom total

Started by Dealio, 09 Jan 2015 01:56:08 PM

Previous topic - Next topic

Dealio

Hi everyone!

I'm trying to figure how to create a custom total. So my situation is I have a list report with an overall total row at the bottom. Now my dilemma is I need to add a new total row where only certain rows get totaled. I still need the overall total row, and I'm not sure how to create a total row that only sums the rows I tell it to. Any advice?

Thanks!

Robl

There are a few ways, but one option would be to add an additional column to the report containing a calculation along the lines of;
If (required row) then (value) else (0)

Then you could just total that column.
Then hide the column if you don't want to see it.