Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mskusace
Creator
Creator

Pivot Table - Change Background Color Depending on Group Average

I have a pivot table with "Pay Period End Date" as rows and I have the type of labor as columns along with the amount. I have included fictitious and a small data set below. If the cell is greater than the TOTAL column average, highlight it a certain color. If the cell is less than the TOTAL column average, highlight it a different color.

Dimension: Pay Period End Date

Measure:s Hours Type

                      Amount

 RegularOvertime
Pay Period End DateAvg. HoursAvg. AmountAvg. HourAvg. Amount
Totals38$4,7503$300
2019-06-0140$5,0005$500
2019-06-1536$4,5001$100

 

What should my expression be based on the dimension and measures I am using? Any guidance or assistance would be greatly appreciated!

Labels (1)
1 Reply
mskusace
Creator
Creator
Author

I modified the data set slightly so it's more evident.

 Regular Overtime 
Pay Period End DateAvg. HoursAvg. AmountAvg. HourAvg. Amount
Totals38$4,7503$100
2019-06-0140$5,0001$100
2019-06-1536$4,5005$500