Dear all experts,
I would like to calculate the rolling last 3 months based on the month of each record and group looped by boutique, could anyone recommend how I can do it in KNIME? Please see below table, and the Rolling past 3 months is the column I would like to create in KNIME.
For example: 2018-12 should be the sum of 2018-12, 2018-11 and 2018-10.
And for the record which does not have previous 2 months record, it will show nothing.
Thanks a lot for your time, and I look forward to hearing from you. Appreciate it!
|BTQ||Year||Month||Sales||Rolling past 3 months|