Hi people,
I have a canvas formula where I am trying to calculate the count of only visible rows of a table.
So as I filter the table using the filter bar, search box or regular filters, this count should change.
How can I do this?
Thanks!
Hi people,
I have a canvas formula where I am trying to calculate the count of only visible rows of a table.
So as I filter the table using the filter bar, search box or regular filters, this count should change.
How can I do this?
Thanks!
Hey @Jeremy_G - References to a source table in a formula will always provide all rows even if there’s a filter on the source table. But references to a view will only return the visible rows. So…
That should do it!