cancel
Showing results for 
Search instead for 
Did you mean: 

Move Grand Totals column in pivot table to the left

omc
7 - Data Storage
7 - Data Storage

I'm trying to move the grand totals column in a pivot table to the left. I have 3 'rows', 1 'column' and 1 'value' in the pivot table.

There is some code to do this in the old community site but it doesn't work in the version of Sisense I'm using (L2022.1.0.102).

Any help would be much appreciated!

1 REPLY 1

Sijo1995
9 - Travel Pro
9 - Travel Pro

Hi @omc ,

Please use this script


widget.on("domready", function(w, args) {

//header columns
var $ps1 = $(".p-grand-total-head,.p-dim-head,.p-dim-member-head", element);
$ps1.css('font-size' , '12px');
$ps1.css('font-weight' , 'bold');
$ps1.css('color' , 'white');
$ps1.css('background-color' , '#26078e');
$ps1.css('text-align' , 'center'); $ps1.css('vertical-align' , 'middle'); //phantom

var $ps2= $(".p-total-row-val,.p-grand-total-row-head", element);
$ps2.css('font-size' , '12px');
$ps2.css('font-weight' , 'bold');
$ps2.css('color' , 'Black');

});