How to sort Pivot Table on high positive and negative numbers

[Mirry]

Hi all,

I've created a Pivot table, which I want to sort on the highest positive and highest negative numbers. Is this possible?

For example, the pivot table numbers are: 3, 0, -3, -1, -2, 1, 2

I want to have the following order:	and don't want ("A to Z"):
3	3
-3	2
2	1
-2	0
1	-1
-1	-2
0	-3

[tr]



Thanks in advance!

 

[Neil_Murray]

Add a calculated field using Abs([FieldToSort])

 

[Mirry]

Thanks! it works