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.
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.
