Pivot table - unable to sort using "show values as/% of row total

Hello,

Both pivot tables have the same data, top table contains count of numbers and bottom table contains percentages of those same numbers. I can sort the top table fine, but I cant sort the bottom table (using the failed column) correctly. It seems the bottom table is sorting but based on the count of numbers and not percentage. How do I sort based on percentage?




b.JPG

Default sorting for PivotTable is on the Grand Total column.

To sort on another column > click on the funnel icon on the Row Labels (not Column Lables) > More Sort Options > click Ascending or Descending > select the column you want to sort

thanks for the reply , I did try this but not go. I decided to just manually sort them. For now I am ok, hopefully this issue wont come back. Ill just mark this as solved. thank you