Hello,
I am trying to group dates in a pivot table by days; every 7 days. The grouping works fine, but the dates are not sorted as should be when sorted "oldest to newest" or "newest to oldest" .
Please see the attached snapshot for better understanding of the issue.
Thank you
I am trying to group dates in a pivot table by days; every 7 days. The grouping works fine, but the dates are not sorted as should be when sorted "oldest to newest" or "newest to oldest" .
Please see the attached snapshot for better understanding of the issue.
![118m6fc.jpg](/board/proxy.php?image=http%3A%2F%2Foi60.tinypic.com%2F118m6fc.jpg&hash=d58d2e579556c05ea9f67f4959c864a7)
Thank you