Color the cell based on the value
Here is the script on how to color the Pivot cell based on the value of this cell.
For example color the cells that contains the value "True":

//Text column formatting
widget.on('ready', function(se, ev){
var evalCol = 12; //fidx val of column to evaluate
var formatCol = $('td.p-dim-member[fidx='+evalCol+']'); //jquery pull entire eval column into array
$.each(formatCol, function(a, b){ //function to loop through array
if(this.textContent == 'True'){ //evaluate text conent of each cell in column's array. note: need to use JavaScript this instead of JQuery $(this), since textContent is a JavaScript attribute.
$(this).css('background-color','#32CD32); //set conditional styling
}
});
});
Updated 03-02-2023
intapiuser
Admin
Joined December 15, 2022