Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to calculate sales for salesman for the next 2 months from the current month. Let us say the current month is july and I want to calculate for august and september.
Try like this
=Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date),+1)))<=$(=MonthEnd(AddMonths(Max(Date),+2)))"}>}Sales)
Regards
ASHFAQ
Hi,
Try like this
=Sum({<MonthDimensionName=, YearDimensionName=, DateDimensionName={">=$(=MonthStart(AddMonths(Max(DateDimensionName),1)))<=$(=MonthEnd(AddMonths(Max(DateDimensionName),2)))"}>}Sales)
Note: Replace MonthDimensionName, YearDimensionName, DateDimensionName with your actual field names.
Regards,
Jagan.