How to add pivoted value to new columns by Magic ETL
I would like to ask how to add pivot value to new column by Magic ETL.
I prepared the table as follows which have value of product for 2021 Apr-Jun and previous year of same month.
I want to add rows and columns highlighted in yellow as shown on the right table by Magic ETL.
The rows that I want to add is 2021 Apr, May, June,
The columns that I want to add is the total of the columns of "pcs" for Same month of the previous year of 2021 Apr, May, June.
I think it seems that it can be done with ranking & window, but I couldn't set. Please advice how to set it concretely?
Thank you very much.