2 Replies Latest reply: Apr 16, 2017 5:37 AM by swati moku RSS

    Color Scheme in pivot table

    swati moku

      Hie,

      I want to apply colors on a range in pivot table, I have used 1 dimension and 1 measure. In measure I have applied a condition where I want to see only outstanding more than 3L and used the following expression

      (Sum({<Outstanding={'>=300000'}>}Outstanding)/100000)

       

      Now, I want  background-color to each range i.e. 3l-5l: green 5l-8l:blue and 8L> red

      but when i am appling the condition the values which are below 3l are also visible which i dont want.

      I have used the following expression :

      if(Outstanding>=300000 and Outstanding<=500000,Green(),

      if( Outstanding>500000 and Outstanding<=800000,Blue(),

      if(Outstanding>800000 ,red(),Null())))

       

       

      Please help me out with this.

      Thank you