Showing results for 
Search instead for 
Did you mean: 

Conditional Formatting on Pivot Text Values

8 - Cloud Apps
8 - Cloud Apps

I am trying to use the script in this post by @intapiuser  to conditionally format cells in a pivot table that contain specific text values but I have found that the formatting does not show up outside of the edit window for the widget. When viewing the dashboard in edit or view mode, there is no color. Has anyone else had this issue? Any idea what the problem could be?


Sisense Team Member
Sisense Team Member

Hey @vrice ,

The article that follows is primarily utilized as a solution for Pivot 1.0, which is deployed by Sisense on Windows machines. However, if Sisense is deployed on a Linux machine, it switches to using the Pivot 2.0 API, which offers a distinct set of JavaScript APIs. You can access the official documentation here and a related community article here.

Within the attached dashboard, you'll find examples of various row and measure formatting. Each widget within the dashboard is equipped with its own unique widget script, all sourced from the Sample Retail (Generic) data.