Total bad calculation in pivot table

[ecabanas]

Hi,

I'm using a pivot table with the units, sales and Standard cost...I did an expression to know the margin in %...every article is well calculated, but the subtotal did not work, could anybody help me?

Thank's

Sum(Aggr(((Sum(EVE_AMOUNTMSTEXCLTAX)+Sum (QTYORDERED)*Avg (COSTEUDCASTD))/Sum(EVE_AMOUNTMSTEXCLTAX)),FAMILIA,ITEMID))

Familia and item are the Dimensions

[whiteline · Accepted solution]

Hi.

The expression gives you the sum of margins:

Sum(Aggr(((Sum(EVE_AMOUNTMSTEXCLTAX)+Sum (QTYORDERED)*Avg (COSTEUDCASTD))/Sum(EVE_AMOUNTMSTEXCLTAX)),FAMILIA,ITEMID))

I think you should first get Sum() for each FAMILIA,ITEMID and then divide it on Sum(EVE_AMOUNTMSTEXCLTAX):

=Sum(Aggr(Sum(EVE_AMOUNTMSTEXCLTAX)+Sum (QTYORDERED)*Avg (COSTEUDCASTD),FAMILIA,ITEMID)) / Sum(EVE_AMOUNTMSTEXCLTAX)

[ecabanas]

Hi Whiteline,

Thank you very much!!!!! EXCELENT!!!