Forum Discussion
Displaying Data - Best way to show a large amount of over/under hours (Pivot)
Hello!
I have a large amount of data (15000+ entries). I am trying to show a way to display those that have worked less than 50 hours and less than 100 hours YTD. I have conditional formatting applied, but can't seem to find how to tweak a pivot table to show this info in the best way. I would be open to another method as well.
| Zone | Region | Location ID | Employee ID | Hire Date | Hours - Last 30 Days | Hours - YTD |
| Central | Asheville | 10 | 0 | 708.97 | ||
| Central | Asheville | 10 | 13.2 | 207.22 | ||
| Central | Asheville | 10 | 3.92 | 51.69 | ||
| Central | Atlanta | 11 | 0 | 21.07 | ||
| Central | Atlanta | 11 | 8.4 | 79.74 |
I would need to be able to show by Zone, region, and location ID quickly to filter down. Right now I have the pivot showing 'Sum of Hours - YTD'.
So, is there a way to filter the 'Sum of Hours - YTD' to only show those under 50 hours in a pivot?
1 Reply
- Yes, you can filter the ‘Sum of Hours - YTD’ to only show those under 50 hours in a pivot table. Here’s how you can do it:
Click on the drop-down arrow of the ‘Sum of Hours - YTD’ field in your pivot table.
Select Value Filters.
From the options, select Less Than.
In the dialog box that appears, enter 50 and click OK
This will filter your pivot table to only show rows where the ‘Sum of Hours - YTD’ is less than 50.
For displaying those that have worked less than 100 hours YTD, you can repeat the process but enter 100 in step 4 instead
Remember, this method filters the pivot table based on the sum of hours, not individual entries. If you want to filter based on individual entries, you might need to use a different method
