Total and row value not as desired for Mix Effect

[kira_whopper]

Hi there,

I have a problem regarding something I got help here in the community for calculating the Mix Effect (the community help solved the issue, but the customer changed the KPI concept).

Attached I'm sending a QVW file and a XLS worksheet.

The problema is that on the first column, the values for the lines are correct, but the total is not the desired one. And then on the second column, the total is correct, mas all rows show wrong values.

Any ideas on how to show the proper values for the columns, with the right total?

Thanks in advance.

FYI, the original problem was solved in this thread:
Sum of Mix Aggregated by Product Presentation

[kira_whopper · Accepted solution]

Found a solution by separating Total Row from the Others inside an IF statement:

if(Count(DISTINCT Dimension) = Count(TOTAL DISTINCT Dimension, ... )

Then, used the respective expression for each case.

Following attached is the qvw with the result.