Perhaps this tutorial will explain better than I did in post #9: https://www.excelcampus.com/pivot-ta...-pivot-tables/
Scroll down to the section titled "Solution # 2 - Using Power Pivot".
Let us know if you have any questions.