Pivot table sorting problem

[nikhilgarg]

Hi,

I have a pivot table with 4 Dimensions and 6 expressions.

I am applying sorting on basis of Expressions but for "others" as value, it is not getting sorted. For ex: my pivot chart due to Others value is looking like:

Dim1  Dim2   Exp1 

A1        Val1     500

            Val2      478

            Others   93

            Val3       450

            Val4       200

Due to this Others as value my sorting gets disrturbed. What can i do for this?

thanks

[Kushal_Chawda]

Can you post the sample application?