Hi
I have a 26 week daily sales data dump that I need to sum X week week to date
I have my week number (1, 2.. 26) along row 1, split out by Sunday, Monday... Saturday in row 2 with sales data below
Below is required output, how can I go about this?
<tbody>
</tbody>
Thanks
I have a 26 week daily sales data dump that I need to sum X week week to date
I have my week number (1, 2.. 26) along row 1, split out by Sunday, Monday... Saturday in row 2 with sales data below
Below is required output, how can I go about this?
1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
Product | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
A | 88 | 70 | 57 | 78 | 29 | 87 | 44 | 78 | 53 | 87 | 91 | 68 | 49 | 97 | 15 | 10 | 48 | 20 | 65 | 7 | 86 |
B | 31 | 11 | 17 | 79 | 44 | 48 | 36 | 98 | 100 | 3 | 23 | 43 | 4 | 8 | 78 | 49 | 61 | 63 | 10 | 23 | 72 |
C | 100 | 79 | 55 | 96 | 37 | 56 | 90 | 74 | 58 | 84 | 76 | 70 | 12 | 72 | 65 | 60 | 58 | 59 | 86 | 88 | 36 |
D | 2 | 98 | 92 | 12 | 81 | 5 | 18 | 50 | 20 | 24 | 11 | 14 | 44 | 33 | 13 | 23 | 36 | 5 | 35 | 55 | 48 |
E | 64 | 6 | 2 | 54 | 19 | 2 | 30 | 16 | 51 | 45 | 45 | 41 | 10 | 96 | 5 | 22 | 59 | 35 | 76 | 76 | 33 |
Product: | C | ||||||||||||||||||||
Week: | 2 | ||||||||||||||||||||
Day: | Thursday | ||||||||||||||||||||
Result: | 362 |
<tbody>
</tbody>
Thanks