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

Grand Total from subtotals

Started by Esosa, 03 Jan 2020 09:41:04 AM

Previous topic - Next topic

Esosa

How can I get a Grand total variable or expression, with the subtotal results from 2 different pages. The Total () function does not really work for me. I am guessing the first step would be to put both pages in a page set.


CognosPaul

Are the values coming from two separate queries? Is this dimensional or relational?

Esosa

Yes, two different queries due to conflicting filters. Relational.

CognosPaul

Make a singleton, put the subtotal in the properties of the singleton. Nest another singleton into the first one. Put the subtotal into the properties. Using a layout expression do [Query1].[Subtotal] + [Query2].[Subtotal].