If you are unable to create a new account, please email support@bspsoftware.com

 

Can you apply different Conditional formatting at different levels of DMR report

Started by cognosjon, 13 Apr 2011 03:23:01 PM

Previous topic - Next topic

cognosjon

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