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

Embed a crosstab row with fixed numbers

Started by Carl Goodwin, 26 Jan 2014 01:21:10 PM

Previous topic - Next topic

Carl Goodwin

I have a crosstab which returns revenues in a variable number of rows with 8 columns (2 years and 8 quarters). Below the grand total row, I want to add a row with a set of 8 fixed numbers (which change very rarely, and for technical reasons cannot be data sourced in Framework Manager). I then want to add one further crosstab row which adds these fixed numbers to the 8 grand total numbers returned by the query.

I've played with query calculations, defined contents and singletons, but am struggling to find the magic recipe.  Does anyone know if/how this might be achieved?