Pivot Table - Combine values with arrows

Hello Community,

Recently I had the thought of combining a value with an arrow (or anything else I suppose!) within a pivot table.

After getting inspiration from some links to the community 

https://community.sisense.com/t5/widget-dashboard-scripts/pivot-and-table-widget-scripting-for-replacing-values-with/ta-p/25842

https://community.sisense.com/t5/add-ons-plug-ins/pivot2-quot-add-image-indicator-to-a-pivot-table-quot-re/ta-p/9077

I mixed them up with some additional help and I ended up with a template script that:

Based on the pre-defined targetColumns on a pivot table returns both the value & the arrow (example below)

The script is: 

widget.on('initialized', function (ev, se) {
// List of target columns by title
var targetColumns = ['']; // add your column names here

var colorGreen = 'green';
var colorRed = 'red';
var colorOrange = 'orange';

widget.transformPivot({

type: ['value', 'member'] },
function (metadata, cell) {
if (metadata.measure && targetColumns.includes(metadata.measure.title) && metadata.rowIndex !== 0){
var originalValue = cell.value;
var numericValue = (originalValue === null || originalValue === '') ? NaN : Number(originalValue);

var arrowChar = '━'; // Default arrow
var arrowColor = colorOrange; // Default color

if (!isNaN(numericValue)) {
    if (numericValue > 0) {
     arrowChar = '▲';
     arrowColor = colorGreen;
} else if (numericValue < 0) {
     arrowChar = '▼';
     arrowColor = colorRed;
} else {
     arrowChar = '━';
     arrowColor = colorOrange;
}

   var percentage = (numericValue * 100).toFixed(1) + '%';
   cell.content = percentage + ' ' + arrowChar;
} else {
   cell.content = arrowChar;
}

cell.style.color = arrowColor;
}
}
);
});

Notes:

1. The arrows are included when exporting in PDF

Hope you will find this helpful!!