Cumulative Sum in filtered table

Batuhan — Thu, 09 May 2024 14:53:48 GMT

Hello Everyone,

I want to see the cumulative total up to the value I filtered a date variable in a table. However, since I filtered this value, I cannot do this with a formula that includes rowno() or columnno(), because when I filter, only that row/column remains on the screen and this formula naturally returns only the value of that date.

Re: Cumulative Sum in filtered table

mshann01 — Fri, 17 May 2024 21:01:00 GMT

You cannot do this natively in the table as you noticed selecting a value filters the whole table interactively. You could use alternate states and have the filter outside the table in a different state. Then, your expressions for your totals can use set analysis to reference that state and field as part of it's logic. You could alternatively use a variable in an input box that drives the set analysis expression.

topic Cumulative Sum in filtered table in Reporting Service & Alerting

Cumulative Sum in filtered table

Re: Cumulative Sum in filtered table