cancel
Showing results for 
Search instead for 
Did you mean: 
edselv
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: 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!

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:
Contributors
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