Calculate Mean

[#1]

Hello

I have a table with some persons with a number of products connected to each person. How can i calculate the average number of products that persons have?

Example:

PERSONS           PRODUCTS

person1               product1

person1               product2

person1               product3

person2               product4

person3               product5

person3               product6

person4               product7

person4               product8

The average in this example should be 2 since person1 hase three products, person2 has one product and person3 and person4 has two products.

Please, how do i accomplish this in qlikview?

Thank you.

[kji · Accepted solution]

Count(Products)/ Count(distinct Persons)

[#3]

Thank you!