Excel alternatives : Subtotal function

[KamNsi]

Hello! Can't find somethning like Excel SUBTOTAL in Appsheet. Using COUNT and SELECT, or SUM and SELECT is inappropriate since we want to count or sum an already filtered table.

Thanks for advise!

[Marc_Dillon]

---

@KamNsi wrote:

we want to count or sum an already filtered table

---

How is it already filtered? Which function type of SUBTOTAL() are you trying to replicate?

[KamNsi]

Already filtered by Appsheet search tool. You can't know on which columns the user would want to filter the table. To get the total sum or count of filtered rows, i use SUBTOTAL in Excel instead of SUMIFS for which i can combine COUNT and SELECT (or SUM and SELECT) within Appsheet.

[Marc_Dillon]

There's no way to programmatically retrieve what the user has filtered by from the search bar. If you need such functionality, you'd have to build a custom filtering dashboard. Or if you use "group by" with a "group aggregate" in your view, those will automatically update as the user searches.