Hello everyone! Hope everyone is staying safe during the pandemic.
I have a data set that looks like below. I tried searching for the solution in the community but I might be lacking the right search terms to use.
Every month, a new column gets layered over with the data for the most recent month and I need to find the row average for the most recent 6-months.
Looking at my data below, the first table has a calculated average of rows A and B form Jan2020 to Jun2020.
In the second table, a new column for Jul2020 was added and has a calculated average of rows A and B from Feb2020 to Jul2020.
Any help on this would assist me in learning new concepts. As always, thank you so much!
Solved! Go to Solution.
Hi @murthybhs
Here is a workflow for the task.
Output:
Case 1
Case 2
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍