Forum

Dates and data pres...
 
Notifications
Clear all

Dates and data presentation over time with Pivot Tables

2 Posts
1 Users
0 Reactions
68 Views
(@brunomelki)
Posts: 46
Trusted Member
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
(@brunomelki)
Posts: 46
Trusted Member
Topic starter
 

Group ungroup... I got it after I looked at one of your videos.

 
Posted : 22/04/2020 11:39 am
Share: