Hi,
I need help guys, I got problems in creating set analysis for the following:
DATE
| ITEM
| AMOUNT
|
|---|
| 11/20/2012 | HTC | 25555 |
| 11/22/2012 | SAMSUNG | 26800 |
| 11/24/2012 | IPHONE4S | 35400 |
| 11/30/2012 | IPHONE4S | 34758 |
| 12/15/2012 | SAMSUNG | 24390 |
| 12/20/2012 | HTC | 25525 |
| 12/25/2012 | IPHONE5 | 49899 |
| 12/30/2012 | HTC | 25500 |
| 1/2/2013 | HTC | 30200 |
| 1/4/2013 | SAMSUNG | 28930 |
| 1/5/2013 | HTC | 12360 |
| 1/9/2013 | IPHONE4S | 34500 |
| 1/20/2013 | SAMSUNG | 24333 |
| 1/23/2013 | IPHONE4S | 32330 |
SET ANALYSIS FOR EACH ITEMS (TOTAL SALES)
1) This Year
2) Last Year
3) Year-to-date
4) Last-Year-to-date
5) This Month
6) Last Month
Thanks,
Bill
