Need help?

[paulwalker]

Hi All,

How to calculate Bucket based on date

(0-30 days, 30-60 days, 60-90 days and Above 90 days) but based on current year..

Ex:

Date	Sales Qty
1/22/2011	132
1/23/2011	20
1/24/2011	96
1/25/2011	34
1/26/2011	138
1/27/2011	67
1/28/2011	59
1/29/2011	78
1/30/2011	36
1/31/2011	87
2/1/2011	6
2/2/2011	100
2/3/2013	18
2/4/2011	87
2/5/2011	36
5/7/2014	99
5/8/2014	36
5/9/2014	30
5/10/2014	90
5/11/2014	12
5/12/2014	48
5/13/2014	9
5/14/2014	30
5/15/2014	15

here i want show current year data only.....based on year selection..

Thanks in advance........

[paulwalker]

Hi Macro,

I need only 0-30, 31-60, 61-90, Above 90......

suppose i have 2012, 2013, 2014 years data

if i am click 2012 i want to show this year data  (0-30, 31-60, 61-90, Above 90......)

same as 2013 and 2014

by default current year data..

Here 0-30 days means (suppose today 9/18/2014 = back 30 days means 8/20/2014)

see like this

8/20/2014

8/21/2014

8/22/2014

8/23/2014

8/24/2014

8/25/2014

8/26/2014

8/27/2014

8/28/2014

8/29/2014

8/30/2014

8/31/2014

9/1/2014

9/2/2014

9/3/2014

9/4/2014

9/5/2014

9/6/2014

9/7/2014

9/8/2014

9/9/2014

9/10/2014

9/11/2014

9/12/2014

9/13/2014

9/14/2014

9/15/2014

9/16/2014

9/17/2014

9/18/2014

same as 31-60, 61-90 and Above 90  (Above 90 means 91 days to 365 days)

Hope you Understand...

please help me...