We plan to merge the aggregation and grouping functions in the Table view, hopefully in 2.7. You may be able to work around this using DataManager to reorder and aggregate the data, but this will apply to the source data, before the user does any filtering.