7 Replies Latest reply: Jun 6, 2018 12:38 PM by Chris Luscombe RSS

    heat map with pivot table

    Chris Luscombe

      Hey There -

      I have a pivot table with dates across the top (Transaction Date), codes (TCDC) down the side, and sum(Sum Amount) as the measure.  I would like to apply a heat map to make is easy to identify when sum(Sum Amount) for a specific Transaction Date is unusual as compared to the rest Transaction Dates. I have highlighted two days in the attached screenshot that I want to jump out.

       

      I suspect that colormix1 is the way to go, I just cant seem to figure it out.

      pivot ss.jpg