Sort Pivot Table By 'Show Value As'

[Schrinetime]

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!