Line Chart showing Planned Year Sales and Current Month Total

[ZoeM]

Hi Community.

I have a request to show on the planned line chart what the current months total planned is.

The set analysis for the Total Planned for the year is:

Count({$<[Date Type]={'Invoice Dates'},Year,Reference_Only={'No'},YearMonth={">=$(=Date(AddMonths(Max(YearMonth),-11),'MMM YY'))<=$(=Date(AddMonths(Max(YearMonth),6),'MMM YY'))"}>}Sales) 

where the total planned shows 18 months (current fiscal year month sand first 6 months of following year).

I need to show on this chart what this months total planned is (August).

Any help provided will be greatly appreciated.

[vishsaggi]

Do you need help with the expr or something else? Can you share some sample data and your expected output to look into?