Is there a way to get top movers to calculate based off a previous period

[Giridhar.Prabhu]

Hi @tate

See this. The suggestion from @prantika_sinha may be suitable for your requirements as well.

Rolling 12 month Calculation

I’m working on a dashboard where I need to calculate a Rolling 12-Month Total. The calculation works perfectly when I display all the months of data. However, when I apply a filter to display only the past 3 months, the rolling sum calculation automatically adjusts to include only those 3 months, instead of the full 12 months. Example: Data for Months 1 to 12: Month 1: 100 Month 2: 100 Month 3: 100 … Month 12: 100 When I display data for all 12 months, the rolling 12-month total works as e…