Set Analysis

[rahulsingh12]

Hi,

How Should I write my expression if i want the last 6 months data to be selected from the current selected month?

Regards,

[rahulsingh12]

if I give max(datefield) then will it take the current selected date or the max of the date available?

regards,

[sunny_talwar]

Current selected date will be your max date unless you ignore selection in date field using set analysis

[pathiqvd]

Hi Rahul,

      In script level write like this:-

date(MakeDate(Year(Date),Month(Date)),'MM-YYYY') as yy_mm

and write expression as

sum({<yy_mm={">=$(=date(MonthStart(AddMonths(min(yy_mm),-6)),'MM-YYYY'))<=$(=date(max(yy_mm),'MM-YYYY'))"}>}Sales) and also take filter yy_mm field . I think you will get solution.

Regards,