on 07-20-2009 9:48 PM
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)?
Thanks
Hi Maximina,
Use exception Aggregation of "Count" for your CKF based on characterstic "Material".
Thanks
Sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Sachin, I was able to do as you suggested and it worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.