I have two pivot tables that are controlled by a slicer. Each time the user selects a record from the slicer, the pivot tables update. The problem is that the pivot tables are filtered to show to top 10 values, and each time the user selects a record, the values are rearranged and go out of order. I need the records in the pivot tables to order themselves by rank. Note: The second pivot table is not shown in the attached screenshot. Thanks.