How to set columns order including Local Members


I have a report with three columns, lets call them: "Real", "Budget" and "%"(local member). The last one is basically "Real/Budget". Thing is, I want to set this last column as the second column in my report so I will have "Real", "%" and "Budget", but in the Sorting tab of the Report Editor you can't actually select a Local Member in the Sorting Criteria, only the other two. Thus, the order will be "Real", "Budget" and "%".

Any ideas/workarounds? Thanks in advance!

  • SAP Moderator
  • SAP Employee

Hi Lago,

What version of the EPM Add-In are you using?

I just tried this with the latest (SP8 Patch 4) and I was able to get this working using the "Use Excel Cell References" option of the Local Member tab.

See below:



0 View this answer in context