Is there a way to summarize data for just the visible rows in a table?
When I filter records in the lower table, I’d like to see the totals reflected in the Summary table above (it’s summed by Date)
I know I can do it by adding filters to the formula for the summary table, but I need to try different filters and its easy to filter a table, harder to keep changing the summary field formula
Excel has a function where you can add values for only visible records when you filter a table.
Is there a similar ability in Grist?