Dates and data presentation over time with Pivot Tables|Power Pivot|Excel Forum|My Online Training Hub

Hi there,

My DataBase have date in a regular format (dd-mm-yy). Every row is a different day and every day have about 200 different countries. When presenting the data in pivot table I cannot get the date on the x axis since it takes me automaticaly to months quarters and years and summarize the data accordingly. I didn't succeed to get neither a timer. What do I do wrong ?

Attached a shorter version of the database. When I drag the [DateRep] in the x axis, I get the partition in months quarters and years and even some new fields are added to the pivot options.