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.
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board