Hello! I have the following table set up that shows the periods and weeks per period horizontally and the time category vertically. How do you create the three calculations listed: * TTM with 4 month lag (excluding P9 & P10) * 4 Week Month (excluding P9 & P10) * 5 Week Month (excluding P9 & P10) Assume the periods are associated with the beginning/ending of months in a standard calendar year. Thanks in advance! Example.xlsx Snip.PNG

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

Trailing Calculations

Hello!

I have the following table set up that shows the periods and weeks per period horizontally and the time category vertically. How do you create the three calculations listed:

TTM with 4 month lag (excluding P9 & P10)
4 Week Month (excluding P9 & P10)
5 Week Month (excluding P9 & P10)

Assume the periods are associated with the beginning/ending of months in a standard calendar year. Thanks in advance!

Example.xlsx

Snip.PNG

Date Time

Transformation

Time Series

Accepted answers

BrunoPER

Here is my solution

reto.yxmd

All comments

BrunoPER

Here is my solution

reto.yxmd

jsamstad

Fantastic! I'm impressed at how you view and transform data. Cheers! 😀

BrunoPER

Thanks in advance. Hope is helpful. Cheers!.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703