To build the heat map, define a color scale, and change cell coloring based on their values – it is easy to do with Flexmonster API. Refer to our blog post to find out more details on how to create a heat map and apply it to your business data. We have got you covered there.
Refer to the Extended grid customization guide to try more ways to customize the pivot table: alternate row colors, represent numbers by icons, add hyperlinks to cells, and more.