Trailing Calculations

[jsamstad]

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: 

1. TTM with 4 month lag (excluding P9 & P10)
2. 4 Week Month (excluding P9 & P10)
3. 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!

[BrunoPER · Accepted solution]

Here is my solution

[jsamstad]

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

[BrunoPER]

Thanks in advance. Hope is helpful. Cheers!.