3 Replies Latest reply: Apr 17, 2013 12:36 PM by matthew thompson RSS

    Define specific colors in Pie chart for Calculated Dimension

      Hi,

      Is there a way to define specific colors in a Pie chart for one calculated dimesion

      For example the formula i use is

       

      if( ([a]-[b]<=5), '0-5%', if( ([a]-[b] >5 and [a]-[b]<=10), '5-10%' , if( ([a]-[b]>10), '>10%' )))

       

      I want 0 - 5 to be display as "Orange"

                5 - 10 to be display as "Yellow"

                > 10 to be display as "Green"