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
Regular
Overtime
Pay Period End Date
Avg. Hours
Avg. Amount
Avg. Hour
Avg. Amount
Totals
38
$4,750
3
$300
2019-06-01
40
$5,000
5
$500
2019-06-15
36
$4,500
1
$100
What should my expression be based on the dimension and measures I am using? Any guidance or assistance would be greatly appreciated!