Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.