Straight table for multiple metrics sorting

[Anonymous]

I have a straight table with the following multiple metrics:

I want the straight table sorted by 'Value Dispensed' with highest value at the top and i have tried this with the sort option and selecting descending but not getting what i want.  How can i accomplish this?

Regards.

[sunny_talwar]

May be try using the expression you are using for Value Dispensed for all your dimension's sorting expression.

[swuehl]

Your chart seems to be sorted correctly in ascending sort order.

When you are saying 'not getting what I want' when you change order to descending, what do you actually get?

What sort options have you chosen on sort tab? Could you post a screenshot or better, a small sample QVW that demonstrates your issue?

[Anonymous]

Swuehl

Thank you very much.  Please find attached the application.  The sorting i want is exactly the opposite of what is currently shown in the app.

Regards.

[Anonymous]

Sunny thank you for your response

[swuehl · Accepted solution]

Maybe like attached.

In addition to the sort order, I've changed the setting in dimension limits from largest to first 10 values.

edit: The issue arise from the fact that dimenion limits are looking at the first expression, the rank expression in your case.

If you change the order of expressions showing the Value Dispensed expression as first column, you can leave your current dimension limit setting. If you don't want to change the order, you could create a hidden expression just for the dimension limit.

See updated sample file

[Anonymous]

Thank you very much Swuehl