7 Replies Latest reply: Sep 18, 2012 6:01 AM by whiteline _

# Display Avg Value in Total

Hi Everyone,

I have to show Each Items Avg Value in the pivot table liked shown below.

ItemNoQuantityRateTax
ActualValueTotal Cost
I0011090101001000
I00115135151502250
I0011090101001000
I00115135151502250
Total5045050500(6500/50) = 130

How to show this?

Thanks

• ###### Re: Display Avg Value in Total

In the example I used the expression:

Actual Value: Sum(Rate + Tax)

Avg Value: Sum((Rate+Tax)*Quantity)/Sum(Quantity)

Attached file for ur reference.

• ###### Re: Display Avg Value in Total

Hi The Hulk,

What if I have  to show all the rows for ItemNo=I001.

Is this expression works ?

e.g. each row contains different EntryNo.

Thanks.

• ###### Re: Display Avg Value in Total

Sure, in this case you have to intorduce the new dimension.

• ###### Re: Display Avg Value in Total

Hi The Hulk,

Thanks for reply.Even I tried.Its working correctly.

Thanks once again,

• ###### Re: Display Avg Value in Total

Hi.

You can use dimensionality() function to override a calculation of Total Cost for Total row:

=if(dimensionality()=0, Sum(Sum(aggr(ActualValue*Quantity, ItemNo)))/Sum(Quantity), Sum(ActualValue*Quantity))

• ###### Re: Display Avg Value in Total

Hi Whilteline,