Sorting in Pivot Table

[MK_QSL]

Can we sort below this pivot table by

SUM(Sales) for each CustomerName?

[Josh_Good]

Yes.  Since CustomerID is unique to CustomerName you also need to sort CustomerID by Sum(Sales)

[MK_QSL]

actually I need SUM(Sales) to be sorted descending order. Means,,,,,

Customer ID should be ID001, ID002, ID003....etc

and SUM(Sales) should be descending order....

[Josh_Good]

Sort Brand by Sum(Sales) in descending order.

[#5]

Your problem is that you are using a field that contains the same name for all customerName and you have to crear other field creating an unit key for all records or display the customer name as unic column.

You can tu use the customerID&':'&CustomerName to display the code and name together. see qlikview example.

The problem is that qlikview is identifying field named Brand as iqual records. For examplo B1 is tha same in all records.

I hope help you.

[#6]

Here you are the best solution.

I'm sure it works correctly