Feature Request: Native “Grand Total” Footer Row for Table Views
Problem: Currently, there is no native way to display a fixed “Summary Row” at the bottom of a Table View. In financial and portfolio apps, users need to see the Sum or Average or Count of a column (e.g., Total Market Value, Total Dividends) without scrolling away or looking at a separate dashboard.
Current Limitations:
-
Workarounds like using
CONTEXT()in “Display Names” clutter the header and don’t look professional. -
Virtual columns used for “Totaling” can significantly slow down sync times for apps with large datasets (1,000+ rows).
-
Grouped headers (Group Aggregate) are helpful but don’t provide a persistent “Grand Total” that stays visible while scrolling.
Requested Solution: Bring back or implement a Footer Summary Row in the Table View settings.
-
Toggle: A simple “Show Total Row” switch in the UX View settings.
-
Column Specific: Ability to choose which columns to Sum, Average, or Count.
-
Fixed Position: Ideally, this row should remain “frozen” at the bottom of the screen while the user scrolls through the data (similar to how headers are frozen at the top).
Impact: This is a standard feature in nearly every modern data-grid and spreadsheet. Adding this back would drastically improve the UX for investment, inventory, and accounting apps, reducing the need for “hacky” workarounds that impact app performance.