Since the introduction of the new filter bar, the Sum row at the bottom of a table does not reflect the correct value. For example, if I filter on a particular status and I look down at the sum value, it is the total…not based on what filter that is applied. Notion handles this fine and so does Excel. I have to constantly create summary tables or calculated fields above the table. Very annoying for quickly seeing what the aggregate values are when I applied a filter bar filter. Am I missing something?
Interesting catch. The summary does actually notice the personal filter bar though, but only if you trigger its calculation by updating the “old” filter first. Definitely a bug
A temporary solution would be to manually trigger the summary calculation every time you change the filter bar:
- Create a /toggle controller
- Name it something such as X
- Change the “old” filter of the table by appending
AND X
(Or just writingX
) if it was empty - Click the button twice to refresh the table
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.