In this sample, we show you how to visualize the bound data by making the pivot table cells look like a heatmap.
Fashion | Electronics | Beauty and Personal Care | Household | Grand Total | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Watch | Handbag | Apparel | PC | Laptop | Gaming Console | Mobile | Cosmetics | Fragrance | Kitchenware | Furniture | Home Decor | ||
2001-2002 | $10.7K | $12.3K | $7.1K | $10.7K | $8.0K | $6.2K | $5.0K | $12.4K | $16.8K | $8.3K | $11.7K | $12.4K | $121.5K |
2003-2004 | $12.4K | $8.4K | $10.6K | $7.6K | $5.6K | $8.6K | $9.8K | $13.8K | $13.3K | $12.6K | $9.6K | $10.4K | $122.8K |
2005-2006 | $9.2K | $7.6K | $6.3K | $7.4K | $9.2K | $3.7K | $3.7K | $12.8K | $7.8K | $6.0K | $6.4K | $9.7K | $89.8K |
2007-2008 | $7.3K | $8.8K | $8.3K | $2.6K | $2.6K | $7.8K | $9.8K | $11.9K | $14.3K | $8.5K | $6.0K | $8.8K | $96.7K |
2009-2010 | $4.5K | $7.8K | $8.6K | $7.1K | $6.1K | $5.1K | $1.7K | $14.9K | $9.6K | $9.2K | $7.7K | $5.8K | $88.1K |
2011-2012 | $10.2K | $7.4K | $8.0K | $4.0K | $2.8K | $8.7K | $10.8K | $16.5K | $10.7K | $7.4K | $7.9K | $10.1K | $104.6K |
2013-2014 | $8.5K | $9.9K | $7.8K | $9.9K | $8.7K | $4.2K | $3.2K | $12.8K | $8.8K | $5.9K | $8.1K | $10.2K | $98.0K |
2015-2016 | $10.0K | $5.2K | $7.1K | $4.1K | $5.5K | $9.3K | $8.6K | $15.0K | $11.2K | $6.0K | $8.1K | $9.6K | $99.6K |
2017-2018 | $6.6K | $11.8K | $5.7K | $12.5K | $9.5K | $2.9K | $3.7K | $11.1K | $14.7K | $8.3K | $4.5K | $6.1K | $97.4K |
2019-2020 | $8.0K | $9.8K | $6.1K | $5.2K | $4.2K | $8.8K | $8.1K | $13.2K | $11.9K | $9.6K | $9.2K | $5.8K | $99.9K |
Grand Total | $87.4K | $88.9K | $75.6K | $71.2K | $62.3K | $65.4K | $64.5K | $134.3K | $119.0K | $81.7K | $79.3K | $88.7K | $1018.4K |
The Pivot Table provides custom styles for each cell's display using the cell template. Using the cellTemplate property in this sample, we are representing the product-specific monthly sales revenue of the goods sold by an online retailer in a year in the form of a heatmap-like appearance. Each pivot table cell was customized by calculating the lowest and highest values via the enginePopulated event and applying a color scheme based on their range.
More information on the cell template can be found in this documentation section.