Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having a Pivot table which has two Dimensions Namely CustomerID and ProductName and one Measure as Count(OrderID). Now when is sort these dimensions based of on count of Order ID(I am using expression option to sort these dimensions & expression is Count(OrderID) ) ,I am able to sort the First Dimension i.e. Customer ID but when I expand this Dimension to see ProductName ,values don't appear to be sorted.
Can anyone suggest me how to achieve this.?
Thanks in advance.
-VIVEK
See In above screenshot, In First screen I am able to sort CustomerID based on count of orders but when I Expand customerID 1, Product names don't appear to be sorted according to orders.
In pivot table, you have to sort table
first by first dimension
second by second dimension and
so on...
so when you are not expanding customer ID, the sorting looks OK
now when you are expanding CustomerID, the sorting is still OK.. but now every sub item of Customer ID is sorted by COUNT(OrderID).
so it's looks OK to me.
Update : Sort 2nd Dimension by Expression
COUNT(OrderID)
sort second dimension (PROD NAME) too with expression count(ORDID)