Forum

Notifications
Clear all

Pivot Table Sort Dates

2 Posts
2 Users
0 Reactions
147 Views
(@zohar)
Posts: 5
Active Member
Topic starter
 

I have followed the great 'Interactive Excel Project Management' video tutorial.

Although I have struggled with some of the features for some time, almost everything (that was presented) is working for me.

The only thing I have left with (unresolved) is the ability to sort the pivot table according to the start date field. 

It seems that while the start (and end) dates are ungrouped, the pivot table is not able to sort the data accordingly.

Any recommendations of how to resolve this annoying issue will be appreciated.

Thanks

 
Posted : 17/02/2021 12:26 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Zohar,

Welcome to our forum! I'm delighted you were able to make use of the techniques in my Project Management Dashboard tutorial.

If you want to sort by date then the date column must be the first column in the PivotTable.

Mynda

 
Posted : 17/02/2021 8:42 pm
Share: