Rolling 12 Month on filter selection

[RichardLee]

I have a table view that I would like to have a rolling 12 month from a selected date which would be the first column then the previous month and so on.

is this possible with an expression.

so If I select Jan 2023 in the drop down filter I would like the table to show

Jan 2023 | Dec 2022 | Nov 2022 | Oct 2022 and so on.

Thanks

[ogster1974]

sum({<[Date]={">$(=AddMonths(Max([Date]),-12))"}>} Sales)

[RichardLee]

Thanks for that but if I wanted to now limit it a little bit more

sum(if({<[Master Date]={">$(=AddMonths(Max([Master Date]),-1))"}>} and [Data Type]='Actual', Value))

how could I do this?

[ogster1974]

sum(if({<[Master Date]={">$(=AddMonths(Max([Master Date]),-1))"}, [Data Type]={'Actual'}>} Value))

[RichardLee]

Tried that previously and I get an Error in the expression: if takes 2-3 parameters.

[ogster1974 · Accepted solution]

sum({<[Master Date]={">$(=AddMonths(Max([Master Date]),-1))"}, [Data Type]={'Actual'}>} Value)

get rid of the if its unnecessary.

[RichardLee]

Thanks you so much 

[RichardLee]

doesnt seem to work