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

[yaya77]

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~

[#2 · Accepted solution]

Hi @yaya77 

Filtering on Last Years works

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

[#3]

Got it. thank you so much~@L z. 

[#4]

@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