3 Replies Latest reply: Mar 29, 2017 1:16 PM by Yusuf Rawat

# Mark Multiple Max values in Bar chart of each month

Good day

Bar chart

Dimension 1 = Month

Dimension 2 = Year

Expression = Sum( Sales)

There are 3 years , so for Jan there will be 3 groups Jan value 200 , 300 , 500 for 2011 , 2012 , 2014 respectively in a grouped bar chart

For feb , 3 bars  of value 2000 , 1000 , 1200 , for 2011 , 2012 , 2013 respectively

I want to change the background color for the maximum value of each month ,

eg Highlight Maximum the bar with maximum value of the various Januarys

Highlight the bar with Maximum value of the 3 bars for the various Febuarys

and so forth for all months

• ###### Re: Mark Multiple Max values in Bar chart of each month

Like this?

• ###### Re: Mark Multiple Max values in Bar chart of each month

Perhaps something like this: if(sum(Sales)=max(total <Month> aggr(sum(Sales),Month,Year)),color(1),color(3))

• ###### Re: Mark Multiple Max values in Bar chart of each month

Thanks it works

Th part i was missing was month tag after the total  TOTAL <Month> , silly me