Group aggregate

Hi there, plan to have two group aggregate value for a table group. 

First value is count of the records in the particular group, and the other one is the sum of value of certain column.

initially I was planning to accomplish by adding a new column which include the record counting as a group. But it is not working if I further filter the records with the search function on the top.

your help is appreciated, thank you.

0 3 71
3 REPLIES 3

I suggest you to search if there is already a feature idea (which is most likely to be the case) or create your own

Perhaps I ask from a different view.

How can I get the number of records which is displayed in the current table list view?

By using COUNT as the group aggregate and a Group By column that all of the rows have in common (the same value for all of them)

Top Labels in this Space