Hi,
looking for some help with a prob that's driving me mad.
Simplistically what I'm trying to accomplish is to apply different conditional formatting (RED, AMBER, GREEN) at different levels of a hierarchy.
So for a bit more detail..
I've a crosstab built against DMR. For arguments sake it displays
Supermarkets as the rows and months as the columns with Sales value as the measure.
At this top level I have a conditional format applied that gives red, amber and green depending on the values displayed here.
when I drill down on an individual supermarket I see all of the individual stores and their sales, however I need to be able to apply a different Conditional format at this level.
I'm stuck, I think I need to grab the level that I'm at within the hierarchy but I'm not sure how I can do this or how I would use it within the conditional statement.
Anyone able to help?
Thanks