Aggregation by Year and month in set analysis

[Peony]

Hi everyone. I have a data set like the one below (excel version is attached as well):

To receive values for Total Sales and Total Sales YoY measures I use expressions below:
Total Sales:           Sum({<Fiscal_Week_End=, Last_12_Fiscal_Months_Flag={"1"}>} Sales)
Total Sales YoY:    Sum({<Fiscal_Week_End=, Last_12_Fiscal_Months_YoY_Flag={"1"}>} Sales)

As final result I need place "Total Sales YoY" on the same rows with "Total Sales". And I understand that I need to add some aggregation to "Total Sales YoY" to get result. But none of the options I tries does not bring me expected result. Maybe someone has any advice what to do with this case? 

[morgankejerhag · Accepted solution]

So for 2025 feb you want to get the values for 2024 feb as well to do YoY calculation? I would solve this with an As of Calendar. An as of calendar allows you to reach other periods in the data that the current dimension value is slicing.
https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130

[Peony]

@morgankejerhag thank you. This solution is precisely what I needed!