how do i filter my pivot table to only show top ten unique results? i have a column with a count function and when i filter for top 10, sometimes i have over 20 records as most have the same number of count. this then affects the way my dashboard displays and does not fit properly.
what i am trying to do then is filter my pivot to only show ten results regardless of duplicates. is this possible?