Bar Chart Help

[pawwy1415]

Hi ,

Can any one please help me on below requirement.

I have a requirement to show max of month to last 6 months Trends in a Bar chart with Single Measure.

I have Taken

Dimension 1 : =If(MonthDiff<7,[Year-Month],null())

Dimension 2: Flag (Yes/No)

Measure : Sum(Trades)

By these getting the bar chart like below.Here need to add one Average Bar which shows last six months avg without considering the current month

Avg calculation highlighted in yellow 

Please help me on this.

Thanks in advance.

[pawwy1415]

Hi @sunny_talwar , @tresesco , @swuehl 

could you please help me on above requirement.

[sunny_talwar]

Would you be able to provide a sample application where you are trying to do this?

[pawwy1415]

Hi @sunny_talwar 

Sorry I cant share the  application due to Confidential data.

[sunny_talwar]

oh okay... I am sure somebody might be able to help.