Background colours for dates not working

[tinkerz1]

Hi,

I use the below code to make the date dimension in a pivot table, but the following code for coloring the backgorund for dates only works on the first 2 dates, what could be happening not to color the full selection?

=if(Num([Download Month-Year])>=num(MONTHSTART(Min_Date))  and Num([Download Month-Year])<=num(MONTHEND(Max_Date)),[MonthYear])

=if(Num([Download Month-Year])>=num(MONTHSTART(Min_Date)) and Num([Download Month-Year])<=num(MONTHEND(Max_Date)),Yellow())

[tyagishaila]

not getting you. why you have to do every time.

background color is a chart property..

Its independent from  expression value.

if possible share your qvw file.

[tinkerz1]

I sorry I cant can't change send the qvw.

At the moment the date range is 9 months but the user can set the date range to what ever they choose, so coloring specfic cells wont work properly if the date range changes.

Thanks.

[tinkerz1]

Ok solved it, it is a case of unchecking all surpressing values and then looking at the table to only check the surpressing values you need.