You can achieve the sort by converting your perc total calculation to discrete and placing it wherever needed on the rows (or columns depending on your output).
In the attached, I have three sheets
- Unsorted which demonstrates the unsorted list
- Window sorted which demonstrates based on the entire window
- pane sorted which demonstrates the sort per pane
The calc is simple: Sum(Sales) / Window_Sum(Sum(Sales)) << note the use of window_sum here instead of Total - these are table calcs which are aggregate; choosing window_sum over Total() as it offers more flexibility.
I don't see any attached sheets with your response.
But anyways, what I did was I created a calculated field of Grand Total and used it as a filter. And then converted the True and False column as perc total and then sorted them and that worked. I would still like to see your option and try. Thank you for your input though.