Sort options for evdre reports

[Former Member]

We have a standard ECDRE report that we use parameter SortCol1 to sort the report by account alphabetically (A – ascending; D – descending). When we remove this setting, the report will sort per the account hierarchy but parent account comes before the child accounts. Is there a way to sort the EVDRE report exactly the opposite order of the account hierarchy like below. If it’s not possible for BPC 7.5, is it possible for 10.1 with EPM reports?

----child account A1

----child account A2

  …..

--Parent account A

----child account B1

----child account B2

  …..

--Parent account B

----child account C1

----child account C2

  …..

--Parent account C

[jrg_finster3]

In your Memberset Settings you can use PARENTAFTER.

But this only works for some memberset Functions like "ALL"

Example:

Memberset: SELF,ALL,PARENTAFTER

Regards

Jörg