Notifications
Clear all
Power Pivot
2
Posts
1
Users
0
Reactions
68
Views
Topic starter
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.
Posted : 22/04/2020 11:17 am
Topic starter
Group ungroup... I got it after I looked at one of your videos.
Posted : 22/04/2020 11:39 am