Year to date & Month to date

[cedfoning]

Hello, 
I have an issue, 

i have the following table : 

I am new to Qlik and i want to have the following calculated files : 

1)YTD, 

2) Sum of amount for the since the beginning of the year 2022 (without the Yearmonth 202205)

3) Last year YTD

It will be helpful if anybody can help

@Taoufiq_Zarra 

[cedfoning]

Hi again, 
i wanted to know if is it possible to be dynamic ? 
in such a way that when a user filter multiples values in the YrMonth (for exemple 202201 to 202204), the YTD_lastYear shows the datas for the YrMonth selected by the user. 

here is a screenshot of what i did

thanks

[vinieme12 · Accepted solution]

you are making selections in the wrong field, the YEARMONTH  field values 202201,202202....  is associated to the year 2022 data, so effectively you are filtering out the data

if you want to compare same months for current and previous year, you need to make selections in the MONTH field

Make selections in the  Month field (Jan,Feb etc..)  this will work