Aggr function to show customers with "C"-Materials only
first of all: I hope this is not a double post. However, I cannot find my last discussion posted about the same issue.
I am new to this community and hope you can help me solve my current issue. I assume for the more experienced this should not be a big issue - however, I have been struggling with this for quite a while now.
I have created an ABC-analysis in order to classify materials according to their relative importance as part of total sales volume.
I have customer data available to identify which materials have been shipped to which customers.
What I want to achieve:
As a matter of fact, there are some customers which receive A, B and C-classified materials. However, I want to display those customers only which receive "C"-classified materials only.
I assume the aggr function will help here. Unfortunately, I have not yet found out HOW.