I don't know how to get the pivot table react as you want but you might want to take a look at columns E:G in the attached where I have tried to solve it by means of normal formulas.
I have converted your table in Sheet1 to a range but you can convert it back to a table if you want.
|