I have a table that I track deliverable in. In the table each deliverable is a column and I record the date it was received for each project. I was trying to create a pivot table where the rows were year/month, columns were the deliverable's and the body showed the count for each deliverable for each year/month. (see example). Any idea on how to make this work?
<tbody>
</tbody>
Deliverable 1 | Deliverable 2 | Deliverable 3 | Deliverable 4 | Deliverable 5 | Deliverable 6 | ||
2019 | |||||||
Jun | 10 | 5 | 6 | 7 | 9 | 2 | |
July | 4 | 5 | 7 | 6 | |||
Aug | 2 | 5 | |||||
Sept | 4 | 8 | 2 | 1 | |||
2020 | |||||||
Jan | |||||||
Grand Total | 16 | 9 | 19 | 16 | 20 | 3 |
<tbody>
</tbody>