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?
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Deliverable 1[/TD]
[TD]Deliverable 2[/TD]
[TD]Deliverable 3[/TD]
[TD]Deliverable 4[/TD]
[TD]Deliverable 5[/TD]
[TD]Deliverable 6[/TD]
[/TR]
[TR]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jun[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]July[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Aug[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sept[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2020[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Grand Total[/TD]
[TD]16[/TD]
[TD]9[/TD]
[TD]19[/TD]
[TD]16[/TD]
[TD]20[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Deliverable 1[/TD]
[TD]Deliverable 2[/TD]
[TD]Deliverable 3[/TD]
[TD]Deliverable 4[/TD]
[TD]Deliverable 5[/TD]
[TD]Deliverable 6[/TD]
[/TR]
[TR]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jun[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]July[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Aug[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sept[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2020[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Grand Total[/TD]
[TD]16[/TD]
[TD]9[/TD]
[TD]19[/TD]
[TD]16[/TD]
[TD]20[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]