16 Replies Latest reply: Nov 22, 2012 4:11 AM by Anand Chouhan RSS

    Change the Color of Bar depending Upon a condition not on Value

      I have a bar chart in which X-axis represent 12 months & on Y-Axis it is Showing Sum(Sales).I have made a

       

      Reference Line by making use of --(Sum(Sales)/(Count(DISTINCT(month))))----Avererage Value.

       

      I want to change the color of Bar in Bar chart depending upon the following condition:-

       

      if(sum(Sales) >(Sum(Sales)/(Count(DISTINCT(month)))),Blue(),Red())

       

      but it is not working...!

       

      If i but a vlaue in place of Average Calculation then i am getting my Result.

       

      if(sum(Sales) >65,Blue(),Red())

       

      Find the attached Sample Qvd for this Problem.