Hello!
Pivot table is set for conditional formatting - data bars for each value.
Products are in rows and dates (weeks) are in columns.
Formatting counts sum of all weeks and shows a bar for highest sales in all visible data range.
Can it be set to count bars (or color grade) each month (column) separately, so that I get to highlight highest values in each month, not in total of all months?
Pivot table is set for conditional formatting - data bars for each value.
Products are in rows and dates (weeks) are in columns.
Formatting counts sum of all weeks and shows a bar for highest sales in all visible data range.
Can it be set to count bars (or color grade) each month (column) separately, so that I get to highlight highest values in each month, not in total of all months?