Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, Patrick
=Sum(Aggr(sum(QTY)*sum(Coef), Week, Day))
Thank you Andrey it seems works properly.
Regards,
Patrick