Skip to Content
0
Former Member
Jul 18, 2016 at 02:08 PM

How to avoid Column Expansion when Column dimension member is linked to an excel cell reference?

31 Views

Hi,

I have a report format that looks like this-

Cell B7 has formula linked to bell B2. (= EPMOlapMemberO($B$2,"[CATEGORY].[PARENTH1].[ACTUAL]","ACTUAL - Actual","","000"))

Similarly cells C7 and C8 are linked to cell C2

Now, if I try editing the report and instead of Jan,Feb and Mar; I want the view as Feb,Jan,Mar etc then column expansion takes place which is shown below-

My entire report's layout changes. I am having lot of issues regarding this while creating my reports. Can you please tell me a solution to this?

Attachments

Example.png (8.4 kB)
Example2.png (7.5 kB)