Repeat Heading - Report with two members in Rows.

[Former Member]

Hi,

I have a report with the following structure

- Rows are static

- Columns have entity and account.

I want to repeat the headings so I have created three local formulas which are attached to the member "ACCOUNT." One is empty to provide empty line. The other two reference the rows above to provide the titles i.e. heading 1 C$87 and heading 2  C$88.

Problem is the headings get displayed again at the bottom of the report...Any ideas how to get around this? Note I have had to also add formatting to the local formulas for colours etc.

Thanks

[former_member186338 · Accepted solution]

Hi Leo,

Use local member BEFORE dimension, not after!

And then hide original header at top.

Vadim

[Former Member · Accepted solution]

You can use local member after then hide the last one at bottom.

exactly the same solution as you use before then hide the top one.

[former_member186338 · Accepted solution]

I think that the topic author mean that rows are dynamic Number of accounts can vary! Based on some previous discussion

[Former Member]

Hi Leo,

The other option will be to hide those last rows, as it is an static report.

I think the problem might be that there is a local blank member somewhere, where did you add the local member? in entity or account?

Andy

[Former Member]

hi Leo,

Have you tried repeat row headers?

Andy

[Former Member]

Hi,

It was already ticked and i unticked it and then selected it again.

made no different - not  too sure what that option is supposed to.

cheers,

[former_member186338]

This option has no relation to the issue described!

Vadim