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

Conditional style not working in crosstab

Started by RubenvdLinden, 01 Feb 2013 06:41:12 AM

Previous topic - Next topic

RubenvdLinden

I have a crosstab with months in columns, organizational units in rows and a measure based on percentages. I have summaries for both columns and rows.

The query contains a dataitem "My Target" (aggregation functions set to 'None') which has the value 0,05.

I have created this conditional style:
[qryReport].[My Measure] > [qryReport].[My Target]

I then added "My Target" to the properties of the Month dataitem in columns.

The conditional style works fine for both the fact cells and the rows summary, but not for the columns summary.

If I change the conditional style to:
[qryReport].[My Measure] > 0,05

it works fine, but since I use the target value multiple times in the same report I would prefer to store it once in a dataitem instead of hardcoding it every time I use it.