Forum Discussion

yaya77's avatar
yaya77
Copper Contributor
Jun 30, 2023
Solved

will the filter "Last Month" auto change the year if the current month is January in pivot table?

Dear all,

Do you happen to know will the filter "Last Month" work if the current month is January in pivot table?

I meant to say the year will the filter auto changed into "2021-12" as well if the current month is "2022-01"? Thank you~

 

excel
  • Lorenzo's avatar
    Lorenzo
    Jun 30, 2023

    Hi yaya77 

     

    Filtering on Last Years works

    So (except bug) in Jan 2024 Last Month should give you figures from Dec 2023 no problem

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jun 30, 2023

    Hi yaya77 

     

    Filtering on Last Years works

    So (except bug) in Jan 2024 Last Month should give you figures from Dec 2023 no problem

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Jun 30, 2023

        yaya77 

        You're welcome. I wanted to double-check Last Month with a year change. But after changing my system date my 365 subscription wasn't valid/recognized anymore so I couldn't do anything on the PivotTable

Resources