2 Replies Latest reply: Oct 30, 2012 7:47 AM by Eduard Cabanas Gili RSS

    Total bad calculation in pivot table

    Eduard Cabanas Gili

      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

       

      table.jpg