My requirement is something like this:
%py sales
Week1- 15%
Week2-25%
Week3 35%
Week438
Total January 38%
We have stored values like this: month=2
Quarter=3
Year=4
And we need to format on month,quarter and year.I wrote a expression like this :
if([Report Query].=2)and [Report Query].[% vs. LY] <%value then ('green')
else if
([Report Query].=3) and [Report Query].[% vs. LY] between %value and %value then ('yellow')
else if
([Report Query].=4) and [Report Query].[% vs. LY]>1 then ('Red')
It is not coming up right.please help.Thanks