# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Contributor

## Total bad calculation in pivot table

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

1 Solution

Accepted Solutions
Honored Contributor II

## Re: Total bad calculation in pivot table

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)

2 Replies
Honored Contributor II

## Re: Total bad calculation in pivot table

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)

Contributor

## Re: Total bad calculation in pivot table

Hi Whiteline,

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

Community Browser