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
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