Dear community,
I faced some challenges in building the alteryx workflow as the data presented were different as compared to normal. Below are query on how to build the workflow.
1. Normally we can minus the data against different columns. However, my data need to minus against different rows. May i know how can we do in this case? For example in the case below, in order to derive cell C50, i need to take C9 and minus against C17,C22,C27,C32 and C37 to arrive the number at C50. I also attached the excel in the working below.
May i know if anyone experience before and how to build this workflow? Row 50 to 60 are my results (after deduction of all relevant row)
2. The second challenge is the data need to be calculated on weekly basis. The data from row 3 to row 34 are constant for all the four week. While from row 36 to row 44, the data show by weekly basis. I would need the result data at weekly basis as shown in the excel file from row 50 to 60.
The above concept apply to all the columns.
It would be highly appreciated if you could assist to build sample workflow on how to derive the final output.
Many thanks for your help in advance.
