sort order in pivot table

[#1]

Hi,

How to sort the data as -3, +3, -8, +8 in this format in pivot table.

In my app calculated dimesion is  as follows : =if(Lens#=1,'-3',if(Lens#=2,'+3',if(Lens#=3,'-8','+8')))

Thanks in advance.

Regards,

Venkat

[#2 · Accepted solution]

Hey,

You can sort by an expression.

Try sorting it by Lens#

gr.

Frank

[#3]

hi, thanks for reply.

I tried but it is not getting correct order.

Thanks & Regards,

Venkat

[#4]

Could you upload an example file?

[#5]

try this out in the sort settings by expression:

if(Lens#<0, Lens# * -1, Lens#)

It should solve your problem

regards,

MT

[#6]

Hi kbs,

Could u please explain ur Expression?

if(Lens#<0, Lens# * -1, Lens#)

Because It is fine with sorting, I don't know how it  works?

Please explain me.

Thanks in advance..

Regards,

Kabilan K.