Yes, there is a workaround to sort data as percent of row in Excel 2007 and newer versions. Here are the steps:

1. Create a pivot table with the data you want to analyze.
2. Click on any cell within the pivot table to activate the PivotTable Tools contextual tab.
3. Click on the "Design" tab and then click on "Report Layout" in the "Layout" group.
4. Select "Show in Tabular Form" to display the data in a tabular format.
5. Click on any cell within the pivot table to activate the PivotTable Tools contextual tab again.
6. Click on the "Options" tab and then click on "Fields, Items, & Sets" in the "Calculations" group.
7. Select the field that you want to sort as a percent of row and click on "Value Field Settings".
8. In the "Value Field Settings" dialog box, select "Show Values As" and then select "% of Row Total" from the drop-down list.
9. Click on "OK" to close the dialog box.
10. Right-click on any cell within the pivot table and select "Sort" from the context menu.
11. In the "Sort" dialog box, select the field that you want to sort and then select "Descending" or "Ascending" as desired.
12. 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.