Color Formatting Pivot table
I have a pivot table that shows the sales by location for each month. I need to highlight the maximum sales month for each location. I have used Html conditioning formatting on a single column, but since this is a row-level comparison I am not sure how it can be done.
Here's what I have
Here's the desired output
I am comfortable writing SQL so open to dataflow transformation ideas as well.