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;
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Actual Sales[/TD]
[TD]Budgeted Sale[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]80[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]60[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]110[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]750[/TD]
[TD]749[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]340[/TD]
[TD]300[/TD]
[/TR]
</tbody>[/TABLE]
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;
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Actual Sales[/TD]
[TD]Budgeted Sale[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]80[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]60[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]110[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]750[/TD]
[TD]749[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]340[/TD]
[TD]300[/TD]
[/TR]
</tbody>[/TABLE]