# Sort Pivot Table By 'Show Value As'

#### Schrinetime

##### New Member
Hello,

I would like to sort my Pivot Table by a value shown as '% of Row Total'. When I try to do this, the table is sorted instead by the actual value (the count). Is there a way to sort by the 'Shown As' value instead of the actual value?

An example of my Pivot Table is below. Here, the Pivot Table is sorted (Row Label > Sort Options/Ascending/% > More Options > Column C), but instead of using the % values in Column C, the table is sorted by the # Values in Column B. (Column B and C both represent the same source data. Column B is a Count while Column C is a '% of Row Total').

 A B C D E F G H N B SB TOTAL # R. Label # % # % # % Adam 6 24% 16 64% 3 12% 25 Ben 9 50% 9 50% 0 0% 18 Charlie 9 50% 9 50% 0 0% 18 Doug 10 56% 8 44% 0 0% 18 Evan 11 58% 6 32% 2 11% 19 Frank 12 67% 6 33% 0 0% 18 George 12 50% 10 42% 2 8% 24 Harold 13 76% 4 24% 0 0% 17 Isaiah 13 76% 4 24% 0 0% 17 Jeff 13 65% 7 35% 0 0% 20

<tbody>
</tbody>

I would like to sort the table and get the following results:

 A B C D E F G H N B SB TOTAL # R. Label # % # % # % Adam 6 24% 16 64% 3 12% 25 Ben 9 50% 9 50% 0 0% 18 Charlie 9 50% 9 50% 0 0% 18 George 12 50% 10 42% 2 8% 24 Doug 10 56% 8 44% 0 0% 18 Evan 11 58% 6 32% 2 11% 19 Jeff 13 65% 7 35% 0 0% 20 Frank 12 67% 6 33% 0 0% 18 Harold 13 76% 4 24% 0 0% 17 Isaiah 13 76% 4 24% 0 0% 17

<tbody>
</tbody>

Any help or direction would be appreciated. Thanks!

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Replies
4
Views
143
Replies
4
Views
79
Replies
13
Views
465
Replies
2
Views
121
Replies
11
Views
465

1,203,071
Messages
6,053,369
Members
444,658
Latest member
lhollingsworth

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back