cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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
}
});
});
Version history
Last update:
‎03-02-2023 09:22 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy