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