How to do sorting when dimension expanded in Pivot Table

SatyaPaleti — Mon, 26 Oct 2015 15:48:54 GMT

Hi Friends,

Need a help.

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

Re: How to do sorting when dimension expanded in Pivot Table

sinanozdemir — Mon, 26 Oct 2015 16:04:30 GMT

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.

topic Re: How to do sorting when dimension expanded in Pivot Table in QlikView

How to do sorting when dimension expanded in Pivot Table

Re: How to do sorting when dimension expanded in Pivot Table