Drill Down Group - hide/reveal columns on different levels

[#1]

I have a drilldown group where the top dimension is our ten major cost groups. Each of these groups have a target value which is just a static number.

I have a straight table displaying these and the row will be green if below standard and red if above. However I want to hide the Standard column and disable the coloring (the color is just an if statement in the background color setting in the table) as soon as someone drill down in the group. The drill down goes down all the way to the base accounts but we don't have any target values below top level in the hierarchy.

The target values are just linked directly to the top dimension in my table, thereby showing up for all accounts once you start to drill down.

Any one has any nice ideas how to deal with this?

[#2 · Accepted solution]

The only way I know to detect if is a drill down is made is the following expression :

if (Count (DISTINCT your_upper_level_field)>1, then , [else] )

May be you can use this in an calculation condition or in a conditional show condition :

for example make two copy of your table, the first one with objectives, the second one without it.
one the first one use Count (DISTINCT your_upper_level_field)>1 in the Layout / show / conditional

in the second Count (DISTINCT your_upper_level_field)<=1 in the Layout / show / conditional.

and place the two tables at the same place.

I know it is an "homemade" solution but it should helps you to do what you want

Regards