Sorting in Pivot table

[Zubair]

I want to sort column GM CPL ascending order in pivot table, please help.

Pivot Table

Description	Month	Volume	GM $	GM CPL
Product A	Jan	1000	2500	2.5
Product A	Feb	9010	-8000	-0.89
Product A	Mar	2010	5245	2.61
Product B	Jan	3254	-2514	-0.77
Product B	Feb	5000	4512	0.9
Product B	Mar	4851	2452	0.51
Product C	Jan	2514	-3514	-1.4
Product C	Feb	1021	-2542	-2.49

Result required in Pivot Table

Description	Month	Volume	GM $	GM CPL
Product C	Feb	1021	-2542	-2.49
Product C	Jan	2514	-3514	-1.40
Product A	Feb	9010	-8000	-0.89
Product B	Jan	3254	-2514	-0.77
Product B	Mar	4851	2452	0.51
Product B	Feb	5000	4512	0.90
Product A	Jan	1000	2500	2.50
Product A	Mar	2010	5245	2.61

Or if any formula available assuming 1st Pivot Table shown above is data and formula need to apply on last column and remaining rows may shorted based on GM CPL?

 

[jsb1921]

click on any row under GM CPL, right click, sort.
If that worked, pl mark it as the solution

 

[Zubair]

click on any row under GM CPL, right click, sort.
If that worked, pl mark it as the solution

Hi Jsb1921, many thanks for your answer but its not working, just to give you more information, This pivot table array contained thousands of rows and many columns and the result shown above is part of it, so its not workable with what you suggested.