Missed your "complex agg" reply - yes that'd also be possible but it's a GUI setting you have to explicitly choose and if once forgotten or changed will again cause "wrong" results.

It's a "you have to die one death" type of situation, I agree.

Is this with the average logic in the formula?

avg( whatever you had before)

?

Now you lost me, are you saying you want; -

A. SUM(MAX(fact column by dim1) BY dim2, dim3)/SUM(MAX(fact column by dim1, dim2, dim3) BY dim3, dim2)

or

B. avg(SUM(MAX(fact column by dim1) BY dim2, dim3)/SUM(MAX(fact column by dim1, dim2, dim3) BY dim3, dim2))

??

Dear User,

Please follow below steps:

1. Edit your column

2. Enter the formula as below:

avg(SUM(MAX(fact column by dim1) BY dim2, dim3)/SUM(MAX(fact column by dim1, dim2, dim3) BY dim3, dim2))

3. From the dropdown (where you selected AVG, please select Server Complex Aggregate) as shown below:

This is what Robert is trying to say.