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.