Reports with headings repeated

[Former Member]

Hi,

I have a report as detailed below and the user wants the headings to be repeated for different set of accounts.

Currently i have three reports which share the same axis and i have offset the reports so they are spaced out. Additionally I have added the headings in between and all works ok.

Ideally only want one report for performance reasons so have tried to space the reports out by having one report and local members providing the space. If i try adding the headings they disappear once the report is refreshed.

Any ideas or do i stick to three reports?

Cheers,

[former_member186338 · Accepted solution]

Hi Leo,

Just create required local members with column axis member descriptions and attach to required row axis members...

Vadim

[Former Member · Accepted solution]

Hi,

Please note that the report I am using using static headings at the top which have been created using member recognition. An enhanced view of the report is below. I currently hide the rows which show the measure (Periodic/YTD) and date in Excel.

So it looks like

I am not sure if the above will change your answer.

I have just tried to add local members to the report and attach it to the row axis and this adds the spaces but between the relevant members. How to do i add the headings "Actual", "Plan" and "Variance"?

Cheers,

[former_member186338 · Accepted solution]

Hi Leo,

In the local member formula you can simply reference the heading row (with $).

=C$39

Vadim