How to accumulate a sum from a specific period backwards

[duncan]

Hello @July !

To make sure I understand what you want, according to your screenshot, you would expect to see 3,409 rather than 23,633?

Have you tried the solution outlined here:

Compute sum of last 3 months volume

Hi, What are the possible ways to get the running total for last n months. Im currently using windowsum but if i apply a date filter the result is incorrect. windowSum(sum({volume}),[{period} ASC],3,0)-{Total Volume} result: the figures are correct in this screenshot [image] But if i apply a date filter. the result is incorrect. In screenshot below, i filtered to start on March 2023. [image] Thanks