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

Hide/show a crosstab column based on drill-down status of anothe column

Started by chrja, 12 Feb 2009 01:15:34 PM

Previous topic - Next topic

chrja

Hello,

In a crosstab report, I have a drillbale column, Company, expandable into Depts etc. I'd like the Company level to be stationary, so when drilling down to Depts, the Company column will still show in the report.

My idea was to make two Company columns, one not drillable (being the fixed Company total) and the other drillable. I would then hide the fixed column when Company level is chosen.

The problem is I can't find out what to base my condition variable on. How on earth can I fetch whether the Company or a child level has been chosen?

Grateful for any help!