Hello, in the below table i'd like to add a column summing the occurences of same week # for each store.
for example - Store 115 - 1 for 49, 50, 51, 52
store 160 - 1 for 50, 51, 52
store 161 - 2 for 49, 2 for 50
<colgroup><col><col></colgroup><tbody>
</tbody>
for example - Store 115 - 1 for 49, 50, 51, 52
store 160 - 1 for 50, 51, 52
store 161 - 2 for 49, 2 for 50
Week # | Store # |
49 | Store ##00115 |
50 | Store ##00115 |
51 | Store ##00115 |
52 | Store ##00115 |
50 | Store ##00160 |
51 | Store ##00160 |
52 | Store ##00160 |
49 | Store ##00161 |
49 | Store ##00161 |
50 | Store ##00161 |
50 | Store ##00161 |
<colgroup><col><col></colgroup><tbody>
</tbody>