topic Pivote Sort in Water Cooler

Pivote Sort

Wed, 14 May 2014 14:07:33 GMT

Hi All,

Can any one help on the below issue.

I have a pivot table shown below

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

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,

maleksafa — Wed, 14 May 2014 14:10:47 GMT

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 — Wed, 14 May 2014 14:25:41 GMT

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

Use this in the expression

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

Wed, 14 May 2014 14:34:29 GMT

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,