Dynamic calculation of last x column

Hello All,

I'm new in Alteryx. And I'm struggling to create this calculation.

So I have report for full year in which have 52 weeks, but I want to make calculation for last 4 weeks base on current week.

Example:

Today we are week 11,year 2020, i want to sum the value of 11 10 9 8. Next week will be 12 I want calc of 12 11 10 9 week. But if is week 2 I want calc to take weeks from previous year (2019), so 52 51 01 02 weeks.

If anyone can help, I'll be really thankful! 🙂

You can find attache xls for example.

Report.xlsx

Accepted answers

Jonathan-Sherman

Hi @DTankova1,

Is this what you're trying to achieve? I've broken the 4 week running total by individual brand.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

20200320 - DynamicCalculationRunningTotal.yxzp

RolandSchubert

Hi @DTankova1,

you can find the current week using DateTime-functions, filter out the last 4 weeks using a Filter tool and Summarize grouped by brand. Join the results to your original data and you're done. I've attached a sample workflow. Let me know, if it solves your problem.