calculation of range of products

[#1]

hi all,

I have following issue. Need to know the relatively range of products a customer has. I have a total range of products available (pricelist)

let's say 4000 units and a customer based product range, let's say 400 units .... so the result is 10%...

unfortunately I cannot find the funktion how to unlock the total available products from the selection I do, when I selcect a customer.

At the moment I always get 100% because both figures are linked to the selection criteria.

Hope you can help, thanx

Oliver

[#2]

A big THANK YOU to all of you!

[davidrobles]

Try count(distinct Artikel)/count(distinct all Artikel)

[#4]

Hey guys, 

I am given a task to calculate the frequency of calls across a territory. If the rep called a physician regarding the sale of the product 5 times, then frequency is 5 and HCP count is 1....I generated frequencies from 1 to 124 in my pivot table using a calculated dimension which is working fine. But my concern is :

My manager wants frequencies till 19 in order from 1..2..3..4...5..6.....19...

And from the frequency 21-124 as 20+.

I would be grateful if someone helps me with this.....Eager for the reply....