Thank you for the reaply, but I have a filed in my data set which contans date (let say daty wise sale). Now i want to show Last week, last week -1 ,current month, Last month sale.
Load DateField, Sales, Week(DateField) as Week, Month(DateField) as Month,
If(Week = Max(Week-1), Dual('Last Week',1),
If(Week = Max(Week-2), Dual('Last Week - 1',2),
If(Month = Max(Month), Dual('Current Month',3),
If(Month = Max(Month-1), Dual('Last Month Sale',4))))) as [Dates Buckets]
Resident Sample;
Drop Table Sample;
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
[start_date] - this is the field of "Date". You have insert to the script in the link proposed a code snippet, replacing [start_date] on your field name of date. Further on the list you must create a listbox and use it in the field [Date Range].
When you load the script in the variable v_today writes the current date. Selections are performed in the list. The desired ranges of selections you can add or change the code.
