Hi I am developing a Quarterly report where there will be 13 weeks in a quarter (always) and need to display quantities against that 13 weeks.
First Month has 4 weeks, 2nd month has 4 weeks and 3 month has 5 weeks all the time. I have a Data dimension table which will tell me the Week number (Col1) and the Month number (col2) that week belongs to....
My problem is I have Quantities aggregated at month level in the table. I have split these monthly quantities into Weekly Quantities.
My data:
| Bucket Data | Quantities |
| 2/1/2014 | 15 |
| 3/1/2014 | 5 |
| 4/1/2014 | 4 |
Desired Output:
| Month | Week | Quantities |
| 2/1/2014 | 1 | 4 |
| 2/1/2014 | 2 | 4 |
| 2/1/2014 | 3 | 4 |
| 2/1/2014 | 4 | 3 |
| 3/1/2014 | 5 | 2 |
| 3/1/2014 | 6 | 1 |
| 3/1/2014 | 7 | 1 |
| 3/1/2014 | 8 | 1 |
| 4/1/2014 | 9 | 1 |
| 4/1/2014 | 10 | 1 |
| 4/1/2014 | 11 | 1 |
| 4/1/2014 | 12 | 1 |
| 4/1/2014 | 13 | 0 |
Thanks