Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ttwward1
Contributor
Contributor

Change background color on the entire right cell row in a vizlib pivot table based on condition

Hello,

I would like to change the row background to darkgray() and bold the cells of a VizLib pivot table version 3.0.0.

If the Dimension value is equal to a certain value, the highlight the entire row. 

I added a Dynamic Styling condition to the dimension and it works for that diminsion,

Example:

Field:ACCOUNT_FORMAL_NAME

List of values(s) 

='Totals'

Background color is set to Gray

Font is set to Bold

I added this condition under the field ACCOUNT_FORMAL_NAME

 

Then I added this same condition to the remaining  dimensions after the ACCOUNT_FORMAL_NAME field, and to the measures, but the field did not change to darkgray for that row.

 

I also tried changing the Cell Styling in the Appearance section, I added  this expression to the background   =if(ACCOUNT_FORMAL_NAME_HLD = 'Totals',DarkGray(), '#ffffff') 

 

Please help.

 

Thank you.

0 Replies