Hi,

we want to built a rather large P&L with time in columns and account and cost center in the rows.

We would like to insert some subtotals within the P&L strucure using simple excel formula's.

So we create the P&L structure and leave some empty rows in between, which are filled up with excell formula's. The row key range is adapted, so it does not reference the excell formula's. If we hit refresh workbook, our P&L is ready and displaying the correct data.

Problem now is if we select 'expand all'. My entire P&L structure is changed and displayes the last section of the row key range several times (as many as we have different row key ranges) ... I've put "noexpand" on all of the dimensions on row and column ...

So normally does one use the functionality of excell formula's within a EVDRE report?

D

solved it

## The Best Answer

Hi D

One way is to switch of the expansions and insert the rows and then have the subtotals. to swith of expansion just edit the cell where you have written the evdre function and then remove the formulas pointing to expand range.

EVSUB in after range would not work here as the whole range is related to one dimension and it works if we have two dimensions and need subtotals

Regards

Harish B K