• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table - Filtering Date based on Column Fields

A

ah_mktanlys_01

New Member
I have a pivot table with multiple fields in it including start and end date. I want the data to be in order (oldest to newest) but based on what is in the first 3 columns. When I try to sort by start date in the pivot table, it does not update correctly. Is there a way to do this with a pivot table?
 

Attachments

  • Excel Pivot Table Filtering 2 columns_Excel Forum_04.16.2024.xlsx
    24.6 KB · Views: 2
If You do as You've written then it works correct.
One possible to sort with Start Date the whole data is below:
Screenshot 2024-04-16 at 22.36.32.png
... or what is Your expected result?
 
You must log in or register to reply here.
Back
Top