Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Do you need help with the expr or something else? Can you share some sample data and your expected output to look into?