Forum Discussion

omc's avatar
omc
Data Storage
02-19-2022

Move Grand Totals column in pivot table to the left

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...
dashboards & reporting
Sijo1995's avatar
Sijo1995
Cloud Apps
10-14-2022

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

});