A tough nut to crack: Excel pivot table layout

So here's a tricky one. (At least for me)   I'm trying to set up a worksheet in order to organize and visualize data. The best way to do that, was instinctively a pivot table.    The first probl...