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

Crosstab summary calculation

Started by TheDarkKnight, 29 Jan 2010 01:13:33 AM

Previous topic - Next topic

TheDarkKnight

Hi Pals,
In Crosstab, is it possible to use the summary data item for a calculation. For eg..ina a simple sense,i have a crstab with product type, year, revenue.i have the summary of revenues at the bottom as total(product type).
i tried to insert have another summary below and modified its calc as total(product type) /2 to get half of the revenue. This gives me an error as edge insconsistent.

Suggestions pls.

Cheers!!!

MFGF

Hi,

Wouldn't the expression be total([Revenue] for [Year])/2

Does this give you the correct result if you define it as a Query Calculation stacked directly below the summary footer?

MF.
Meep!