Sum of Average

[rahulsud007]

Dear All,

I need to find sum of all the average which I have calculated and Multiplied by previous coloumn

In the below application the 0-1 value field calculates the average amount and multiplied by Quantity and I would need sum as shown in the image.

Please Help ..:)

[mohamed_ahid]

hi

use column(n) .

exemple :your total column will be like : column (1) + column (2) ....

[rahulsud007]

Hi,

Here i am not saying about sum of just that particular coloumn in the image u can see total 4,4524 for sum from 0-1M

but v need 8167

[mohamed_ahid]

like this ?

[rahulsud007]

Hi Ahid,

Bit similar but if calculate the sum is wrong it should be 8637.

[jonathandienst]

Use this syntax

=Sum(Aggr(<your average expression here>, <chart dimensions>))

<chart dimensions> is a comma separated list of the dimensions  from your chart or table.

For example

=Sum(Aggr(Avg(Amount), Customer, Month, Year))

[rahulsud007]

Hi Jonathon,

I have tried this expression it gives me '0' as value. May be it is because I am using Pick Match in my expression so

For the Sum field it is not taking as Dimension.