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:
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)?