Skip to Content
Former Member
Jul 20, 2009 at 08:48 PM

BI 7.0 Calculated Key Figure- Material Counter


I have a Query requirement and hope that someone can assist me on this. I have a CKF that basically counts the number of Materials. Below is an outline of my query:

Rows Columns

Materials Customers Material Counter

Lets say that I have 1500 Materials and I only drilldown by Materials, my Material Counter will give me the correct # of Materials, which is 1500. However, if I drilldown by Material & Customer, I will have multiple customers per material on many occasions.

I understand that my counter is counting the line items. Is there a way to keep the drilldown by Material and Customer and still only count the Materials (ignoring the customer drilldowns)?