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?

Hi Bob,

You can do that from the Pivot >> Data Groupings >> Values >> Appearance. You can Use Custom Data Point Appearance.

The following examples are using conditional Custom Data Point Appearance:

Box And Whiskers Chart

Range Selection Chart

You can also review the following Help Documentation topics:
Editors > Property Editors
Editors > Appearance FX Editors > Fill Style FX Editor

Hopefully this helps.

Works great!

This topic was also quite helpful: http://forum.nevron.com/shwmessage.aspx?ForumID=13&MessageID=7456

Thanks!