matrix - change color based on data trend up or down

I have a dataset with customer, date and count columns. Then I have a matrix
based on that information as follows:
Oct 2007 Sep 2007 Aug 2007
Customer A 123 432 959
Customer B 984 394 345
Customer C 2459 2335 234
I would like to have the color of the count red if the number is lower for
that customer for the next date (i.e. 123) and green if the number is higher
for the next date (i.e. 984).
Any idea how I do this?
StephanieOn Oct 1, 9:49 am, Stephanie <Stepha...@.discussions.microsoft.com>
wrote:
> I have a dataset with customer, date and count columns. Then I have a matrix
> based on that information as follows:
> Oct 2007 Sep 2007 Aug 2007
> Customer A 123 432 959
> Customer B 984 394 345
> Customer C 2459 2335 234
> I would like to have the color of the count red if the number is lower for
> that customer for the next date (i.e. 123) and green if the number is higher
> for the next date (i.e. 984).
> Any idea how I do this?
> Stephanie
You might be able to use 'iif' in conjunction with the 'Previous'
function to set the background color. I'm not sure of the exact
syntax, but this might lead you in the right direction.
=iif(Previous(Fields!Count.Value) < Fields!Count.Value, "Green",
"Red")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant