Set analysis for months

[Anonymous]

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.

[ashfaq_haseeb]

Try like this

=Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date),+1)))<=$(=MonthEnd(AddMonths(Max(Date),+2)))"}>}Sales)

Regards

ASHFAQ

[jagan]

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.