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