Yes. I need it like this but in the 1-5 reports we have a Daily report and in the final report I want to use those data from the Daily report - calculate it according to the Week vise and generate an answer automatically. Does it make sense? or you want me to elaborate?
Superstore has 4 columns:
You must try this format with your 1-5 reports. Or you can share your workbook here. Thank you