Hi everyone,
I have a created a pivot table in which I sum quantities of delivered products (rows). I'd like to filter the quantities/deliveries by date.
However, the filter dates are not showing up in chronological order as shown below on the left-hand side:
Picture.png
As I have roughly 500 dates, this is quite a nuisance. I have tried changing the date format in the raw data to YY-MM-D so that it shows up in chronological order, but this does not solve the issue (even though the raw data now show up in the format I would like them to).
Any ideas on how to solve this? Surely it must be straightforward to filter dates in chronological order.
Thank you for any assistance.
Bookmarks