Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Exclude values less than X total hours
06-09-2023
01:46 AM
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 |
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
04:15 AM

You can do this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
04:01 AM

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?

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
11-01-2024 02:44 AM | |||
08-26-2024 07:32 AM | |||
10-10-2024 03:01 PM | |||
03-19-2024 08:26 PM | |||
07-22-2024 01:50 PM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |