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!
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');
});
