Sort records using expression in pivot table

[#1]

Hi,

I'm using a pivot table that contains two dimensions and i want to sort records in descending mode. I'm using expression but it is not working to all records.

Here you are images containing the expression.

[vinieme12]

apply the same to the second dimension and try

, This can be tricky at times...so try to sort by Ascending once to see if it does the trick

[neelamsaroha157]

It would be great if you can share some sample data to play with.

[#4]

I just apply the same expression to all dimensions and it doesn't work correctly.

[awhitfield]

Or even better, a sample qvw?

Andy

[#6]

I can't to share de qvw because is confidencial information but supose that you have the next structure:

Category          Sub-Category        Product            TotalSales

Aqua                Li                         Product 1           20,000.00

Aqua                ML                       Product 2           10,000.00

Aqua                LI                         Product 3           5,000.00

Aqua                LI                         Product 4           15,000.00

Aqua                ML                       Product 4           4,000.00

for ML sub-category it sort correctly but to LI sub-category doesn't work correctly.