how to port a report from evdre to EPM Add-In?

Hi,

I have a report in BPC 7.5 using EVDRE that shows me entities in columns. It is a dynamic report, meaning the entities shown are determined by the expansion range. The expansion range is defined by a simply Excel formula:

if(currency=LC;bas(GROUP);bas(GROUP),GROUP)

in other words, when the report is run in local currency it shows me all my entities across with no total at the end and when it is run in converted currency I get all entities and then the total group at the end.

How do I create such a report in the EPM Add-In for BPC 10? I have tried to use a local member to calculate the total and then hide all empty and zero value columns, but that functionality does not seem to inlcude local members.

Is there a way to create my report (dynamically, so that when I add a new entitiy it is visible in the report without any further changes)?

Thanks,

Arnold