Profile Picture

Change the color of a bar if value is above 10

Posted By Bob Smith 11 Years Ago
Author
Message
Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

I realize that this question should have a simple answer, but it seems that the application is more complicated.

I would like to use an "IF" statement to change the fill color of a bar in a bar chart if the sum of "Sales" for an item is above the 10.

To get the value of each item's sum of sales simply FIRST(SUM(Fields!Sum_Of_Sales)). But how do I apply this value into a condition that will change the color of the bar?






Similar Topics


Reading This Topic