Table Headings issue - Local Formulas

Hi,

I have a report which has the following settings

Rows

Accounts A - member and children

Accounts B - member and children

Accounts C - member only

Column

Static as per screenshot below

Local Members (rows)

Blank Line - Attached to member Accounts A (after)

Area B Heading - Attached to "Blank Line" local member (after)

Blank Line After Area B - Attached to "Area B Heading" local member (after)

Table 2 Heading 1 - Attached to "Blank Line After Area B" local member (after) - this is for Month / YTD heading for table 2

Table 2 Heading 2 - Attached to "Table 2 Heading 1" local member (after) - this is Actual/Plan/Var heading

There are additional local members for the headings for table 3 (Area C) but this are linked directly to "Account C"

The problem i have is that if i run the report is that if there is no data for Area B the report looks like the below. This is because i linked the headings to Account A in the first table. I cant link it to table 2 (Area B) because the children of Account B change.

Any ideas on how to get around this?

Cheers