To achieve your goal.
1)Drag Subcategory,Category,Duplicate of Subcategory
2)Disable "Show Header" of Duplicate of Subcategory
3)Drag your Sales% Calculation in Text field
4)Set Sales% in Descending Order
Note:-Subcategory should be in ascending order
For More Detail Please Refer Below attachment.
Sorting_Param_v10.5.twbx 2.1 MB
I don't think this solution work out in my case. Because I see it is doing manual sort and when there is change in data, sort order will remains in the same order, but not dynamically based on % value change.
Also, I would need to provide users the ability to sort by Category, which is missing here, either with parameter or single click. Pls let me know if you have any other solution without using sheet swapping.