The data which you've provided has Date-Month-Day in same column + numeric's. Instead add Dates-month-day as a row
You can get the dates by creating a calendar and mapping it to the fact, I find there is no use to include those hence it is hard to make not just pivot table but any table.
If you can edit your data by removing unnecessary field names? PFA (Sheet 2 in your XL file) for the sample data I've edited. Defining rows will be more easier.
If you can do it or if the DB team can do it for you?
If this is not coming directly from source and if this is just a flat file then you can define it properly instead of worrying or you can try the example provided above by Marco.
Thanks.
