Exception on keyfigure depending on 3 characteristics

30 Views

Hi Experts,

I am facing a problem in exceptions of query designing.The scenario is there are 2 characteristics and one keyfigure. the keyfigure (KF) needs to be highlighted according to the 2 characterisctics

Eg if

employee factory sales(KF)

old old red3

new new white

in fact the salary colour also depends on another charactristic months:

if sales > 0 then colour of the KF should be green irrespectve of the 2 characteristics

if sales = 0 then colour of the KF should be maintained according to the table above.

i have a listed a small scenario.

the problem is not with when sales >0 this condition is being satisfied but when month = 0 I am not able to include the conditions

Is this possible using an exception, or any other method for that matter.Please do suggest.

Edited by: Beauty on Mar 25, 2010 1:54 PM