Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
first of all: this is my first post here and I think this is a great community!
As I have been struggling with this issue for quite a while now, I decided to register myself, hoping you can help me solve my issue.
I assume it's not a big thing, though, I am stuck here.
Plot:
I created an ABC-analysis in order to classify materials based on their importance with regards to total sales volume.
I have Customer data available to match these materials to the respective customers.
What I need to achieve:
As a matter of fact, there are some customers, which receive A, B & C-classified materials. However, I want to display those customers only which receive "C"-classified materials only.
I assume, aggr function will help here. Unfortunately, I do not know how to use it.
Thanks a lot in advance for your help!
felipeflamenco
Ship-To | ABC_Material | count(distinct(Material)) |
Customer 1 | A | 1 |
Customer 2 | A | 2 |
Customer 3 | A | 1 |
Customer 4 | A | 5 |
Customer 4 | B | 2 |
Customer 4 | C | 1 |
Customer 5 | A | 4 |
Customer 5 | A | 3 |
Customer 6 | A | 4 |
Customer 6 | A | 4 |
Customer 7 | A | 9 |
Customer 7 | B | 1 |
Customer 8 | A | 5 |
Customer 9 | A | 7 |
Customer 9 | B | 1 |
Customer 10 | A | 10 |
Customer 10 | B | 4 |
Customer 10 | C | 1 |
Customer 11 | A | 3 |
Customer 12 | A | 1 |
Customer 12 | C | 1 |
Customer 13 | A | 1 |
Customer 14 | A | 1 |
Customer 15 | B | 1 |
Customer 15 | C | 1 |
Customer 16 | A | 1 |
Customer 17 | C | 1 |
Customer 18 | A | 2 |
Customer 19 | A | 2 |
Customer 19 | B | 2 |
Customer 20 | A | 1 |
Customer 20 | C | 3 |
Thanks a alot. Still a little difficult to read but a great approach.
Hi all,
I found a workaround.
I classified all customers into A, AB, AC, ABC, B, BC or C-customers.
This is how I did it:
Thanks a lot for your support!
Regards