Dimension Member Sorting in BPC Excel Report

[Former Member]

hi BPC Gurus

I've a question on the Excel Report.

I've created a report which have 4 dimensions in the Row Axis

In the last axis, I want to sort it according to the ID in Ascending Order. How do I do that?

I tried to sort it in "Member Sorting and Grouping" by "Enable Member Sorting" Order "Ascending" but it did not work....

[former_member186338]

Group by ID:

Vadim