regarding set analysis exp?

[d_koti24]

Hi All,

I want display the data weekly wise and monthly wise in chart.How to achive this?

weekly -today() to last monday

monthly-29/06/2015 to 29/05/2015

regards,

kd

[buzzy996]

u can try this way,u can create drill-down group with ur week and Month data fields,by changes the those/selecting (either week or month) on chart u can get corresponding information in ur chart.

[#3]

Hi,

You need to use like below,

As per your requirement,

=sum({<CalDate = {">=$(=Date(max(CalDate)-31))<=$(=max(CalDate)) "},CalQuarter=,CalMonth=,CalYear=>}Sales)

Another approach,

=sum({<CalDate = {">=$(=Date(Monthstart(max(CalDate))))<=$(=max(CalDate)) "},CalQuarter=,CalMonth=,CalYear=>}Sales)

=Sum({<CalMonthYear={"$(=Monthname((Max(CalDate))))"}>} Sales)

=Sum({<CalWeek={"$(=week((Max(CalDate))))"}>} Sales)