Heat map in pivot

[sachi1982]

Hi All,
I needed to create a heat map in my pivot table. My data comprises of actual sale, budgeted sales. i want to create a heat map to show which product are performing above the budget and below the budget in a color format( like the heat map) but i want to show the actual sales in the pivot table as pivot value. So that when sales team look at it they know what is the actual sales they did and color code show them whether they are above or below the budget. Thanks for your help.

my data is something like below;

Product	Actual Sales	Budgeted Sale
A	80	100
B	60	75
C	110	100
D	750	749
E	340	300

<tbody>
</tbody>

 

[sachi1982]

hi All,

Any help on this.

 

[Smitty]

If you don't already have one in your dataset, I'd add a calculated column(s) for %/$ to Budget, then use Conditional Formatting Data Bars or Color Scales to highlight performance.

 

[sachi1982]

Hi, thanks for the response. But i intend to show the actual sales value rather than the percentage.