need to fix calculated value when table is aggregated

[patrou38]

Hello,

I need your help, because I'm totaly lost in front my issue.

I tried to replicate my problem in a simple attached example .

I have a table with 1 week, 7days. 1 Quantity (Qty), 1 coefficient (Coef) and 1 column in wicth I do the Quantity * Coefficient.

it's ok with this, but My problem is that I've to a visibility by Week (instead detailed by days).

When I removed the column 'Day' (either by removing the dimension or by collapsing the column in the pivot table), I obtained a new amount in the calculated column (last one) correspont to the  sum of the column Qty * sum of the column Coef.

maybe this is a correct behavior of the tool, but this is not what I would like have. what I would like to obtain in this column is the sum of each day (corresponig to 9369 instead 104827.

I hope that it's enough clear for you.

thank you in advance for your help.

Patrick

[andrey_krylov · Accepted solution]

Hi, Patrick

=Sum(Aggr(sum(QTY)*sum(Coef), Week, Day))

[patrou38]

Thank you Andrey it seems works properly.

Regards,

Patrick