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

Conditionall highlight crosstab rows based on the values in columns

Started by leoraj, 06 Aug 2009 04:13:02 PM

Previous topic - Next topic

leoraj

Hi All,

Can anybody help me with conditional formatting in crosstabs please?
I have a cross tab with Employee branch, employee name, email ID as nested rows of my crosstab respectively and sales, revenue are my columns.
I want to conditionally highlight the employee name is sales =0.
Please help.

Raj

Birdie

Hi Raj-

In order to do this, you'll need to:

*Create a boolean variable. Something like "sales =0" should work fine.

*Then you need apply that variable to any columns you want to highlight the rows for (this will highlight the intersected rows and columns values). In your case, you should apply the variable to sales (and revenue if you want the entire row for an employee name highlighted).

*If you also want the employee name and email id highlighted, apply the variable to those rows as well.

Note: when you apply the variable, choose a background color you want to use as your highlighter.

I have a few crosstab reports I use this method on, so if you'd like more details let me know.

good luck!

JoOne

Hello Birdie,

This is exactly what I need as well. I know how to create a boolean value, but how do I apply it to a column?

Best regards,
Johan

Birdie

Hi Johan-

In order to apply it to the columns/rows, you need to click on the area of the crosstab you want highlighted.

Next, you want to hover over the Explorer Bar in the Variables area. A fly out window will show, which contains your Boolean Variable. Click either the "Yes" or "No" option (depending on when you want your data to be highlighted. For example, if your variable expression is "sales= 0" and you want to see all rows where someone had "0" sales, you would click the "Yes" option on the fly-out window.)

Next, in the Properties pane to the left of the page, click the "Style Variable" property.

Choose your boolean variable from the drop down menu in the Style Variables box.

Click Ok

Click the "Background Color" property from the Properties pane (again on the left).

Apply whatever color you want to highlight your rows with.

You'll need to apply the boolean variable to each row/column you want highlighted.


leoraj

Hi Birdie,
Thanks for the response. What you suggested is correct.
I was actually doing exactly the same thing before, but still the row was not highlighted.
Now, I figured out why. The reason is, in cross tabs after applying the conditional variable to the row/column, go back to the page explorer keeping the row/column selected and in the properties pane under Data/properties click the elipsis and check the query item that you want to apply the condition to. rerun the report, now you can see the row highlighted.

Raj