In cases where we want to display the difference between two columns instead of using the default Grand Totals in Pivot widgets:
Include the following widget script:
function removeCommas(num){
numClean = num.replace(/,/g,"");
return numClean;
};
widget.on("domready", function(){
/* Set text to be shown grand total row*/
var diff = "Difference";
/* set variables and clean local for reading */
var num1 = removeCommas($("#prism-mainview > div > div.errvil-warpper > div > div > div > pivot > div > div.p-fixed-cols > div > table > tbody > tr:nth-child(1) > td.p-value.p-first-data-col > div").text());
var num2 = removeCommas($("#prism-mainview > div > div.errvil-warpper > div > div > div > pivot > div > div.p-fixed-cols > div > table > tbody > tr:nth-child(2) > td.p-value.p-first-data-col > div").text());
/* Change label text*/
$("#prism-mainview > div > div.errvil-warpper > div > div > div > pivot > div > div.p-fixed-cols > div > table > tbody > tr:nth-child(3) > td.p-grand-total-row-head.p-first-data-col > div > div > span").text(diff)
/* Change difference value and add locale format*/
$("#pivot_ > tbody > tr:nth-child(3) > td.p-value.p-first-data-col.p-total-row-val > div").text((num1 - num2).toLocaleString());
});
console.log("background script run");Result:
Disclaimer:
* Tested on version 7.0
* Only works with 2 row Pivot widgets
