Sort Pivot Table On Two Columns

[wsnyder]

Hi all,

Using Excel Office 365.

How can I sort a Pivot Table on 2 Columns?

I have a count of work tasks and an SLA from 0% - 100%

I want to sort the Pivot so the Top 20 opportunities are at the top where a low SLA count with a high work task count should be near the top. If the SLA is high, it should be near the bottom.

I tried to amplify the values Multiplying the work task count by 1000 and dividing the SLA by 1000, but that did not give me the results I am looking for.

Thanks
-lou

 

[wsnyder]

Bump.

thanks
-lou