How to apply a filter to only one column of a tabl...

Hello, I have a table representing the total amount of transactions per company :

Those amount can change when we filter by date.

Now, I would like to create an other column called "Prev tran amount" which represents the total amount of transactions per company but filter with another date filter a second one (preferably the year before).

For example, the first colum will be the total amount from july 202 to december 2022 and the second column will be the total amount from january 2022 to june 2022. With this I will be able to measure the evolution of the amount of transactions between two period. But the thing is I don't know how to connect a second filter date only to the prev transaction amount column without changing all the other ones.