Forum Discussion

SaraOC's avatar
SaraOC
Copper Contributor
Dec 16, 2021

Pivot Table Filter for Months in Chronological Order

I have my raw data filtered chronologically by months of the year. When I create a pivot table, the months show out of chronological order. How do I get the pivot table filter drop down to display mo...
excel
SaraOC's avatar
SaraOC
Copper Contributor
Dec 16, 2021

Riny_van_Eekelen True, but when I convert it to a date the issue remains. 

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 16, 2021

SaraOC But then they are still texts. What do you see when you enter a formula like =ISNUMBER(A1) where A1 would be a cell with a date?

  • SaraOC's avatar
    SaraOC
    Copper Contributor
    Dec 17, 2021

    Riny_van_Eekelen  I get "TRUE" when I type in that formula. 

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 18, 2021

      SaraOC 

      Perhaps you may share how source data looks like mentioning how do you group dates and do you use data model with PivotTable or not.

Resources