Weighted average for a column

[Noobforever]

Weighted average of lifetime 

Hi everyone,   I wanted to calculate weighted average of Lifetime the table given below

And the weights is the total count of each type and subtype. How do I calculate this in the chart (front end).

Want to calculate weighted average for each type and each subtype and display it in a table

Have attached the csv below

[Noobforever]

Hi everyone,   I wanted to calculate weighted average of Lifetime the table given below

And the weights is the total count of each type and subtype. How do I calculate this in the chart (front end).

Want to calculate weighted average for each type and each subtype and display it in a table

Have attached the csv below

[ckarras22]

Hello,

(fom a frozen sample of your file)

[Noobforever]

I need to apply something like this 

A= lifetime * count

B= sum(a)

Weight average= B/count

1 .So each value of lifetime is multiplied by count of that particular type and subtype

2.add the products 

3. Divide the sum of products by count

[ckarras22]

Hello

for Weight average= B/count the count is sum(count)? if not which count value should be taken?!?

In case that count is the number of lines for each Type/Sub-type pair, then what i sent above is what you want.

[Noobforever]

Yes it is sum(count) for each type and sub-type

[ckarras22]

then sum(Count*[Life(in months)])/sum(Count) is the formula for 

"Want to calculate weighted average for each type and each subtype and display it in a table"

[Noobforever]

I am attaching expected result please refer. I have to use aggr I guess

Fo andriodfor touch in andriod