Forum Discussion
How to filter by sum values pivot table
Hi- I am trying to figure out how to filter within my sum values final column of my pivot table. I need to look at values higher than 500 and less than 1000 only within the values and I cannot filter...
The problem with this suggested method is that it only filters for the pivot table rows that are already expanded. If you expand collapsed rows after applying the filter you may still see unwanted rows. I am not sure how this effects totals.
In my use case, below was a more proper solution. In this case, I filtered for all "Bed IDs" where Sum of Blocked Time was greater than 1440 (minutes)