Skip to Content
0
Former Member
Oct 31, 2005 at 09:45 PM

Query: Count a char with respect to another char

17 Views

Hi,

In the query I would like to count the "unique occurances" of a characteristic with respect to another "characteristic". The value should be fixed ipprespective the drill down state of any other char. Any ideas?

Example: I have Material and Customer. and material is in many orders... I would like to get number of Materials a customer has ordered. Well, this can be done if only the "Customer" is in drill down. But, I have customer, material and some other characteristics in the drill down. At any drill down state, I would like to know number of materials ordered by a customer.

I already went thru the white paper, "Count the occurrences of a characteristic relative to one or more other characteristics". This works only when "Customer" is the only object in the drilldown. Doesnt work when additional chars are in the drill down too...

Thanks

Gova