Concept Doubt

Hi, Create horizontal bar chart using Segment and Category with sum of Sales and sort the entire data in descending order using RANK function Using sample superstore data. So I've created the data but not able to sort the data. Wanted the data Rankwise i.e 9,8,7,6,5,4,3,2,1 in that order but here data is also sorted by alphabatically automatically resulting mismatch of order. How can I do that?