Build Running Total Chart that can Filter Across the Page

Hi Ashish,

Thanks for your reply. Sorry that I think you might have misunderstood my question.

I know how to get the 12 month rolling sum. My issue is that my page will have 2 visuals: (1) bar chart of 12m rolling total deal count against close date; (2) A table of the deal data (deal name, deal size, close date.... etc) without any calculations. My ultimate goal is that when I click on any bar in the bar chart, say the bar of date 7 May 2024 (which represent the total count of deals closed during 8 May 23 - 7 May 24), the table will be filtered to get the deal records that make up that bar. I cannot achieve this result - now when I click on the 7 May 2024 bar, the table will only show all the deals with close date on 7 May 2024. 

Sorry if I did not make my question easy to understand. Do you know how can I achieve the result I want?