Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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)