Color the Row and Value fields of a Pivot Table
This article will show you how to quickly color a pivot table into two sections: by Row and by Value
1. Build your pivot table.
2. In the widget editor, add the widget script below. Information on how to add a widget script here: https://sisense.dev/guides/js/extensions.html
widget.transformPivot(
{
type: ['value','member']
},
function setCellBackground(metadata, cell) {
if(metadata.type == 'value'){
cell.style = cell.style || {};
cell.style.backgroundColor = '#9A94BC';
} else {
cell.style = cell.style || {};
cell.style.backgroundColor = '#ffe6e6';
}
}
);
3. Change the colors by changing the color codes above and you're all set!
 
Note: If you'd like to target different parts of the pivot table, refer to our Pivot 2 API documentation.
Updated 02-05-2024
edselv
Cloud Apps
Joined December 08, 2021