Sort Dimension in Pivot

[#1]

Hello,

I need the [order index] (last dimension in pivot) to sort in ascending order. If I promote this dimension to the top it will sort, but I need this granular level in my pivot table. Any suggestions? Attached is the QVW.

Thank you,

EK

[Anonymous · Accepted solution]

In your example, it is enough to move it one step up, before "Sec Diag".  Or, sort "Sec Diag" by expression "order Index"

Regards,

Michael

[#3]

I have neve done the sort by expression that worked. Thank you! Another question I am have is how to include OR logic into an expression or script based on a current selection. Say I want a acct number to be shown if it is in the [Prim Diag] field or the [Sec Diag] field. The Diag code would be the search selection.

Thanks again,

EK

[Anonymous]

You cannot refer to "current selection" in script - during the reload, selections do not exist.  You can though keep info about last selection in a variable, and variables can be used in the script.

Using selection in expression - by deafult expressions take selections into account.  In some cases you want to override it using set analysis.

Anyway, you better open a new discussion for that (more people will read), and try to be more specific 🙂

Regards,
Michael