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!