Skip to Content
0
Jun 05, 2014 at 11:02 AM

Calculating Grand Totals Dinamically

30 Views


Hi all,

On EPM 10, we´ve got two dimensions in columns (profit center, products) and two dimensions in column (time and category) in a dinamic report, as shown below:

To calculate Grand Totals we tried creating local members using these EPM functions:

sum(EPMALLMEMBERS

sum (EPMSELECTEDMEMBERS

These formulas do work, but only if they are used with only one dimension in columns.

Could anyone let us know what we could do for calculating the grand total using two dimensions (and both of these two dimensions are not fixed, i.e. they are dinamic ).

Thanks in advance,

Ana

Attachments

ejem.jpg (31.1 kB)