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!
