'Excel pivot table - sort by multiple columns

I am looking for a solution to sort an Excel pivot table by multiple columns. My pivot table looks like this:

Pivot table

The original data is laid out in the format below, where columns D and E are helper columns (and usually hidden). Column D is always 1, and column E is populated based on the input in the Accomplished column (column C).

Source data layout

In the pivot table, the % Done column is a calculated field that divides Done by Days.

I would like to sort the pivot table first by % Done in descending order (as shown in the picture), but then also by Total Days in descending order, and then by Participant Number in ascending order.

It seems like this should be relatively simple, but I can't seem to figure it out. Any help would be appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source