EPM add-in - how to control sorting without going into report editor?

[Former Member]

Hi all,

I have a bunch of reports that I need to sort according to selected combination of members. However, this combination has to be easily changed for ca. 50 reports.

Report looks as below:

I can sort manually by going into each report by changing sort criteria - but this will be very time consuming.

Question is - how can I automate this? Is there some formula to override this sorting selection? Or maybe I can use VBA somehow to adjust this?

I need some flexible solution. I would prefer to indicate combination of members somewhere, and apply this combination to my reports.

Any advice?

Thanks,

Grzegorz