Dynamic table - set default sort order based on conditionally displayed expressions
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.
Re: Re: Dynamic table - set default sort order based on conditionally displayed expressions
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.