5 Replies Latest reply on May 15, 2013 12:51 AM by Cristian Vasile

    How to do a heat map within a column?

    Kate Abercrombie

      Hi!

       

      I currently have a a data table with salary figures by level and location. Locations are on the left (rows) and the job levels are the columns. I applied a heat map and it applies a darker red to the higher salary figures across all the levels. However, I would like to have to heat map apply the darker red to the highest salary by level. For example, Level 2 people clearly make less than Level 7 individuals. However, because the heat map is considering all salary figures, none of the Level 2 salaries are the dark red color. Is there a way to highlight the highest salaries within each level?

       

      Thank you,

      Kate