Hi everyone, please help me with the following:
I'm trying to calculate the number of occurrence using Pivot Table. My data is as follow (sample)
excel.png
How can I use Pivot table add up the number of occurrence in both Shirt A and Shirt B.
e.g.
black - 'total sum'
green - 'total sum'
blue - 'total sum'
Thanks everyone in advance!
Bookmarks