How to order some members in rows

[Former Member]

Hi experts,

I have a report that I have to do an specific order.

My entity dimension should be on rows with alphabetical order. I got it with this option:

But also I want to add any member (is parent of E_TOTAL_ES and E_TOTAL_RP) in final row. If I add this member I can see it but also with alphabetical order and is not last member.

How can I order some members with alphabetical order and then add another member??

Thanks!

[former_member186338 · Accepted solution]

Only with additional report with shared column and page axis and with the required additional Entity member after main report with alphabetical sorting.

Vadim

[Former Member · Accepted solution]

Thanks for your answer Vadim,

but I try to use EPMRetrieveData function after last row of report and I think that is working fine.

Is that correct? or is better create and aditional report?

Thanks!

[former_member186338 · Accepted solution]

You may have issues with #RFR errors on some refresh scenarios...

And second report works fine in any case

[Former Member · Accepted solution]

Thank you very much Vadim