Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
71
Views
Topic starter
I have a pivot table with a values item that is a distinct count of a date. I want to filter the table using that distinct count but cannot find a way to get that into the filters area.
I'd like to get the table to display every item that has a distinct count less than a certain number. Is there any way to filter the table by that Value?
I cannot share the workbook because it is full of proprietary data.
Posted : 23/05/2023 3:50 pm
Hi Thomas,
Try filtering the ManagerName column, in the column filter menu select Label Filters>Less Than, you will be able to filter the ManagerName column where Count is less than x
Posted : 26/05/2023 12:57 am
