Exclude values less than X total hours

[abfdjuk]

I have data as per below for many companies and I want to create a page filter which will remove any companies that have their total hours less than 100. I have tried using the filters but it doesn't seem to work. Here is a sample of the data:

Law firms - Name	Fees - Time
A	200.00
B	150.00
C	10.00
D	65.00
A	120.00
A	12.00
B	10.00

[BIswajit_Das · Accepted solution]

You can do this

[BIswajit_Das]

Hello @abfdjuk here's a something that might be helpfull

[abfdjuk]

Thanks for your respone. From seeing this what I actually want to do is to total the hours for each law firm, e.g. law firm A = total hours 332, B = 160, C = 10, D= 65 and then exclude/include after that. How would I achieve that?