9 Replies Latest reply: May 24, 2017 3:15 AM by Kamal Kumar Sanguri RSS

    question

    Saran Wanjiru

      Hi,

       

      I am working with pivot table   i want color to my data according to the highest spent and lowest spent amount.

      e.g over spending ranges from >= 1000000  color green() under spending is <1000000 color red()

      How do I create the expression.

       

      PROJECT IDBUDGETACTUAL BUDGETCONSUMED AMOUNTAVAILABLE BALANCEHeader 6Header 7

      001

      200000003000000010000000400000
      00350000014000000567990600000
      0024500000200000002760000100590
      009300000025045003210000471230
      0061500000056800001600005000
      0071200000034600000123000045890
      005500000233333331000000200001
      01016000067777555600006600