3 Replies Latest reply: Dec 16, 2016 8:29 AM by HECTOR GARCIA RSS

    How can we get multiple colour heat map with input box values (esp in Pivot tables)

      Hi all,

      Can you please help me to create Pivot table (Heat Map) with input box values.

      Check below Pivot table:

       

      Pivot table
      Year2009
      MonthJanFebMarApr
      a20%40%80%75%
      b30%30%50%50%
      c40%20%75%80%

       

      Input Box:

      Input Box
      vGreen=0.8
      vBlue=0.5
      vRed=0

       

      vGreen should be >=0.8
      vBlue should be >=0.5 <0.8
      vRed should <0.5

       

      Question: I've created three variables (vGreen, vBlue and vRed) and assigned them to input box to change the numbers manually. How can I change colours in Pivot table if numbers entered manually in Input Box.

      Thanks for your help.


      Regards,

      Sriniv