Period Over Period Alternate solution

[duncan]

Hello @Geetha and @AnwarAli !

@Geetha are you still having trouble with this problem or were you able to find a solution? If so could you post your solution to help the community?

Could you share an anonymized view of the calculations that you attempted?

You could also try the solution posted here:

Trailing data for Q

Hi I think we can only set the absolute value for the date field in the filter. If that’s true, what should I do if let’s say if I type TTM, then Q will know to look at the order_day field and filter for 12 month until the latest complete month (so Sep-Aug if I do it today). TIA!