Yes, there is a workaround to sort data as percent of row in Excel 2007 and newer versions. Here are the steps:
- Create a pivot table with the data you want to analyze.
- Click on any cell within the pivot table to activate the PivotTable Tools contextual tab.
- Click on the "Design" tab and then click on "Report Layout" in the "Layout" group.
- Select "Show in Tabular Form" to display the data in a tabular format.
- Click on any cell within the pivot table to activate the PivotTable Tools contextual tab again.
- Click on the "Options" tab and then click on "Fields, Items, & Sets" in the "Calculations" group.
- Select the field that you want to sort as a percent of row and click on "Value Field Settings".
- In the "Value Field Settings" dialog box, select "Show Values As" and then select "% of Row Total" from the drop-down list.
- Click on "OK" to close the dialog box.
- Right-click on any cell within the pivot table and select "Sort" from the context menu.
- In the "Sort" dialog box, select the field that you want to sort and then select "Descending" or "Ascending" as desired.
- Click on "OK" to close the dialog box.
Your pivot table should now be sorted based on the percent of row total for the selected field.