Compare YOY or Month on Month

[gonhaddock]

Hello @Sid_melb and welcome to the KNIME forum.

Just trying to focus a bit more in the challenge (once I saw your example). We had a post in the forum happened last December month. The challenge was also focused in retail data and difference calculations.

Calculation on changing Column Names

Hello Community, currently I’m wokring on a Workflow which calculates the changes in sales of products. I was able to transform into this: [image] How do I calculate the delta of the columns? Changes from 10 to 11 and 09 to 11 and 08 to 11 when the column names are changing and under the condition that the data is based on months? BR, Sven Edit: I know there is a field Column Index, which maybe will solve my problem, but I don’t know how to identify the column by its index. Edit2: I fou…

There were some differences with your described challenge:

1. the requested granularity was based on a month by month basis (instead of a pinned reference month)
2. the target field was the product instead the client
3. the differentials were presented as quantities instead of percentages

However I think that there are few similarities with that challenge, and maybe you can get some insights from it, aiming to plan your next steps.

BR