How to Arrive weighted average

Q&A
1

Hi Everyone,

I am trying to arrive weighted average, but got struck in arriving the same.my dataset have data like
image

wants to arrive summary like
image

based on the logic

image
image869×449 11.2 KB

can anyone help me in achieving this task

1 Like
2

Hi @sbaskax
so (A) and (B) are exiting fields?!

For (C) i would try:

percentOfTotal
(
     sum(B), 
     [Country]
)

For (D)
It sould be a simple (B)*(C), right?

BR

1 Like
3

@ErikG

Thank you for your reply,

1 Like