Movingsum Function Workaround
I'm have 2 line items
Margin and Moving sum
doing a MOVINGSUM on a line item moving sum. And I would like to capture in my line item where movingsum is done.
I would like to calculate MoM Average between 2021 and 2022. And When MoM margins differ by more than 30% - I will replace the value with the margin percentage for the same month a year ago.
Any Idea how to workaround this?.