Skip to Content

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

Aug 30, 2017 at 07:48 AM


avatar image

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?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers