Script Filter with Condition

[AriefJapfa]

Hello guys..

is there something wrong with my script? I'm not sure about the cal year

=[Cal. Month] >= Month(today())-1 and [Cal. Month] <=Month(today())-1 and [Cal. Year] = {'$(=year(today())-1)'}

this script i want to use in column filter
if normal
[Cal. Year] = '2023' or [Cal. Year] = '2022' and [Cal. Month] = 'Jul'
output like this

#filter 

[JHuis]

Do you have months and years in the same field? 

Maybe you could give me an example of your field?

[AriefJapfa]

thanks for the response@JHuis

 
i have column on pivot table row fully expanded. column name cal. month.

so the output is like this

if to get a month can, using script =[Cal. Month] >= Month(today())-1 and [Cal. Month] <=Month(today())-1

but when you get cal. years can not, [Cal. Year] <=Year(today())

what I'm confused about, if you use a script like this the year it appears

the desired result is like this