Dear all,
I want conditional format by month where ever sales value less than previous month in Matrix report SSRS 2008.
Example: If February Sales less than January Sales then Colour RED else Green in any products and so on for other months.
My Design View Like below:
Mnth <===Column Headings
Row Headings ==>>> PG PG_DESC [SUM(SPD)]
Report Preview look like below:
PGPG_DESC January February March April May June So on..
470Misc. Adjuster Parts £145 £148 £188 £155 £183 £179
471Headlamp Complete £11,014 £11,459 £11,094 £10,931 £10,198 £10,163
I have tried normal IIF function but it's does not do what i want.
Please please help me out.
Reards
Vinay