How to calculate SumProduct

[vismehra]

Hi,
In below analysis, i want to add sumproduct of gvs and pds at the end of the table and then dividing it further with sum of gvs.

For ex, for Ahmedabad city, i want to calculate below expression
sum ( 388631 + 577482 + 56004* 3 …)/ sum (38863+57748+…)

What calculation field i need to build to get 42% output for Ahmedabad {SUMPRODUCT(B5:H5/$B$4:$H$4)/SUM(B5:H5)}

Arena link: fadd sample

Thanks

[prantika_sinha]

Hi @vismehra ,

For sumproduct we can use sum (field1 * field 2).
For your use case have tried to implement the calculation in the analysis copy. Please check the solution here.
[sample solution to 31448]

However, since you are using pivot tables, adding it to same table is not feasible.

Thanks,
Prantika

[vismehra]

Thanks for the help!
It is working now.