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:
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,