How to do sorting when dimension expanded in Pivot Table

[SatyaPaleti]

Hi Friends,

Need a help.

How to do sorting when dimension expanded in Pivot Table

I am having Dimensions as Description, Order# & Company

I am Having Expressions as

Sum(2P Qty),

Sum(OD Qty),

Sum(Present Qty),

Sum(Exact Qty),

Sum(Present Cost),

Sum(Exact Cost)

I have created Pivot Table. I want to show top 5 Exact Cost. Offcourse I done with that but when Company(Dimension) Expanded

Exact Cost(Expression) also should show values from Highest value to Lowest Value.

Here you can see Images

Now I want to show values from highest to lowest when Company(Dimension) Expanded

Here is the Image

Here you can find attached document for Data I am using in the Application and Qvw I created.

Could you please help any one to resolve this Issue

Thank you,

Satya Paleti

[sinanozdemir]

In your example, $918,785.87 is in a different group, "123 Company" and the other values are in "XYZ Company" group so they are separated by the nature of dimensionality. I don't think you can sort the way you desire to in a pivot table.