Skip to Content

Dynamic Sort on multiple Measures do not pose a challenge when it is done on a flat table.

Whereas, while applying sort within section/break, SORT does not happen properly.

As a workaround, we have identified 2 options which are listed below:

Option 1: Using Manage Sort option

Consider a vertical Table with Breaks applied on it.

We need the Table to be arranged based on the first column in it provided the Measure to be sorted based on that column.

For Dynamic Sorting, create a variable with Rank function (with minus operator to make the ascending / descending work correctly for measures) and use that in the table and apply sort on it as below:

/wp-content/uploads/2013/12/1_337746.png

Using Alerters, need to display the required measure.

/wp-content/uploads/2013/12/2_337747.png

/wp-content/uploads/2013/12/3_337763.png

Users can click on the required measure and apply sorting.

/wp-content/uploads/2013/12/4_337765.png

We can see that States are sorted in Ascending order based on the Sales Revenue.

Option 2: Using Input Controls

Apply Rank on Section which is driven dynamically & table within each Section for showing KPI Totals

Using Rank function, create 2 variables (Ascending & Descending) for each Measure to be sorted and have Input Controls to drive the Section dynamically.

/wp-content/uploads/2013/12/5_337766.png

/wp-content/uploads/2013/12/6_337767.png

Sort is enabled at report level.

The most desirable sort can be made as the default one inside the report.

Regards,

Muthulakshmi Ramanathan

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply