Dynamic table - set default sort order based on conditionally displayed expressions

[marcus_malinow]

Hi,

I've run into an issue with the sort order in a straight table.

I have several dimensions, and several conditionally displayed expressions. The condition for the display of these is based on the users' selection of a field in a data island.

My issue is that I set the sort order priority to these expressions, however it seems to be reset every time I open the document, and the priority reverts to the dimensions first, then whichever expressions are enabled.

Does anyone know of a fix for this?

Marcus

[bgerchikov]

Hi Marcus,

You might need to use Expression option in Chart tab with the multiple IF...ELSE conditions since you're using data island to show/hide columns.

Can you post a sample?

Thanks!

[marcus_malinow]

Hi Boris,

I've attached an example. In this, I'd like the sort order priority to default to 'Sales Value' descending, however it seems that the sort order priority is reset when the selections in the Dimension and Measure fields are cleared.

Marcus

[bgerchikov · Accepted solution]

Hi Marcus,

Please review attached.

Thanks!

[marcus_malinow]

Hi Boris,

thanks for this - will give this a go with a small variation - an additional calculated dimension to use as the sort order so that I can still sort on the existing dimensions.

Marcus