Hi @Bhagyashree Sawant
By your explanation, it seems you are fetching info from the database (aggregate) to populate info to the table, and applying what you want will increase complexity.
My advice is to use the fetch data from other sources, where you do the logic to return the list with the records and apply that output to the table, also each time you filter will refresh the DataAction and will recalculate the data as expected.

Hope this helps you.
If not, send the oml and give us more info in order we can analyze and help you better.
Regards
Gonçalo Almeida