Hello All!
I am trying to organize a pivot table to she me subtotals at the bottom of each "group" and also have a count at the top of each "group"
Example: This is what i would like to achieve
<tbody>
</tbody>
Let me know if anyone has any suggestions
I am trying to organize a pivot table to she me subtotals at the bottom of each "group" and also have a count at the top of each "group"
Example: This is what i would like to achieve
Route 1 Count | 2 | 1 | 1 | 2 | 2 | 2 |
Store 1 | 5 | 30 | 15 | |||
Store 3 | 40 | 1 | ||||
Store 5 | 2 | 15 | 52 | |||
Store 7 | 45 | 8 | ||||
Route 1 Total | 7 | 15 | 40 | 75 | 53 | 23 |
Route 2 Count | 3 | 2 | 2 | 2 | 2 | 1 |
Store 2 | 51 | 2 | 3 | |||
Store 4 | 14 | 2 | 2 | |||
Store 6 | 11 | 2 | 21 | |||
Store 8 | 11 | 5 | 47 | |||
Route 2 Total | 73 | 19 | 4 | 23 | 50 | 2 |
<tbody>
</tbody>
Let me know if anyone has any suggestions