Forum Discussion

yaya77's avatar
yaya77
Copper Contributor
Jun 29, 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 ...
excel
  • Lorenzo's avatar
    Lorenzo
    Jun 29, 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 29, 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

yaya77's avatar
yaya77
Copper Contributor
Jun 30, 2023

Got it. thank you so much~Lorenzo 

  • 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