Pivote Sort

[#1]

Hi All,

Can any one help on the below issue.

I have a pivot table shown below

BEFORE
PHYSICAN	VALUE
OTHERS	476
FETES	56
CROTZER	76
GERSHMAN	99
JOSEPH	123
BAXTER	34
JOHN	56
TOTAL	920

Now I want the "OTHERS" category to be shown at the bottom (Shown below)

AFTER
PHYSICAN	VALUE
FETES	56
CROTZER	76
GERSHMAN	99
JOSEPH	123
BAXTER	34
JOHN	34
OTHERS	476
TOTAL	920

Note: I dont want to use the sort values by Accending here. Only the Other should be shown below and the rest should remain the same.

Thanks in advance.

Regards,

KK

[maleksafa]

Hi,

you can use the dual function to assign a number for the values and give 'OTHERS' the highest number and sort by numeric value asc.

[anbu1984]

Chart properties --> Sort --> Dimension( Select the dimension )

Use this in the expression

If(PHYSICAN<> 'OTHERS',1,2)

[#4]

Hi Anbu,

Thanks for your reply,

But I have a issue here,,,

In my SORT DIMENSION I have already a expression

"({<Product,AST_PROMO_FLG,Product,$(v26Weeks)>} $(vVALUE)) " so where can I put this function  "If(PHYSICAN<> 'OTHERS',1,2)"

Thanks,

KK