Local member affecting the drill down.

Dear Friends,

I am designing dynamic a report in BPC 10 NW. In this report I am using few local member. But the position of these local member affect the drill down. I am using choice of ‘Insert local member after __ row/position’.

For example, I am creating local member ‘GROSS REVENUE’ and this local member user formula ‘Revenue by sales’ + ‘Revenue by other sources’ and I have inserted local member (GROSS REVENUE) in ROW after 2 rows. Now when the client do a drill down in ‘Revenue by other sources’
the whole report gets disturbed as the local formula still remain in third row. Client is not interested in using dimension formula.

How can I have local member move with the drill down.

Thanks,

Nisha