EPM Sorting Issue

[Former Member]

Hi, I'd like to ask if there's a way to sort certain grouping in ascending orders. For example, I want crewcount and crewnight to be on the top two rows and only sort H1_SALARY_RELATED (the rest of it) in ascending order.

We already tried to use the sorting field in the formatting tab, but it will sort all accounts and crewcount & crewnight will appear on the bottom. Using BPC 10.1. Thank you.

[former_member186338 · Accepted solution]

The only way is to change hierarchy order of members...

And some not elegant approach:

Use 2 reports with shared page and column axis:

1. crewcount & crewnight

2. Other members with sorting

[Former Member · Accepted solution]

Thank you!