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 Highlight for Crosstab

Started by Arsenal, 23 May 2007 09:15:13 PM

Previous topic - Next topic

Arsenal

Hey all,


I have about 6 measures in my crosstab. For four of those measures, I need to highlight the negative values in red, including their summaries(totals)

I have no problem in highlighting the column values. However, the totals (which I got by using the summary function from the toolbar) is giving me a problem.

The data item created by the summary function when used directly (it is something like Total For All States) as an expression like <0 in a boolean function gives a data mismatch error

so then, I tried to be clever and create 4 different variables with expressions that said something like (total (amount1) for report) <0 but that now gives me a parsing error

Please...somebody must be having an easy way to do this :-\

HELP!!!!!

goose

I hard without a screenshot but I did this crosstab below, I created a condition thats checks if sales_units > 1000 and set the style variable for all the measures to this. Then said if condition is true make font red. The summary values will also work correctly cause they are based on this measure.




Arsenal

Goose,

thanka for the reply. Did you, in the condition, directly say that sales_units>1000 ?

Btw, how did u get that sales_units like that in ur crosstab?

the rows for me just can't have any heading :(

although, i could unlock and drag a text item

goose

Yes I just said [sales_units] > 1000. The heading (1,2,3,4) is another measure fin_week, but if I wanted the heading to be sales_units you can drag the measure to the column too.

Arsenal