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,

Thanks for your reply..I marked your answered as correct because..Use of Dimensionality() is important to show two different calcalation in one column.

Thanks once again.

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

I understand

You're welcome.