Showing results for 
Search instead for 
Did you mean: 
Sisense Team Member
Sisense Team Member

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:


        type: ['value','member']
    function setCellBackground(metadata, cell) {
		if(metadata.type == 'value'){ = || {}; = '#9A94BC';
		} else { = || {}; = '#ffe6e6';


3. Change the colors by changing the color codes above and you're all set!

Screen Shot 2022-03-31 at 14.57.40.png

Note: If you'd like to target different parts of the pivot table, refer to our Pivot 2 API documentation.

Version history
Last update:
‎03-02-2023 10:12 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy