Excel 2010 Pivot Table vs Open Office Calc 3 Data Pilot

Having trouble making a proper pivot table in excel, not sure what I'm doing wrong. Basically trying to reproduce the results I get in OOc with excel. What am I doing wrong? Thanks in advance. Please don't comment suggesting I upgrade OO to Libre Office instead or to not use MS Excel either.This video is about solving a specific problem. Not the philosophy of using various OOS vs commercial apps.