Product share

[#1]

Hello!

I have this problem.

I want to calculate the proportion of goods. This is small example

Order1          Order2          Order3

product1     product1         product2

product2     product2         

                 product3

product1 = 1/2 (this order1) + 1/3+ 0

product2 = 1/2+1/3+1

product3= 0+1/3+0

I want to have a table:

product1      0,83

product2      1,83

product3       0,3

Thanks!

[sunny_talwar · Accepted solution]

May be like this:

=Sum(Aggr(Count(Product)/Count(TOTAL <OrderNum> Product), OrderNum, Product))

[Kushal_Chawda]

Can you share the sample data?

[#4]

Thank you very much