Forum Discussion

PipSqueak's avatar
PipSqueak
Frequent Visitor
6 years ago

AB Classification / Pareto Principle quad analysis

I'm looking to create a quad analysis model which will filter by branch/region/company/date. It uses 2 dimensions (Products and Customers) and classed into 4 classifications AA, AB, BA, BB which uses the 80/20 pareto principle of each dimension. The following are the steps:

1) Cumulative Sales By Customer

2) Cumulative Sales By Products

3) Rank both in descending order

4) Customers which makes 80% of sales are classed as A, the remaining are classed as B

5) Products which makes 80% of sales are classed as A, the remaining are classed as B

6) Group by Customers and Products

7) Combine both classes based on groups

😎Preferably a scattergraph/quad chart that groups AA,AB,BA,BB.... if not a scattergraph, a card displaying the cumulative total of each quads for each filter.

 

Please let me know it's possible to make it dynamically filter? Or if not, are there other solutions out there that can do this? Links to pictures which hopefully will clear up what I'm trying to explain.

Paste Data: https://drive.google.com/file/d/1W9zyjZp4H8g6APW_-z3iP7k_FL8g2wok/view?usp=sharing
Product Rank: https://drive.google.com/file/d/1_u5-KkERlqh32I-eZ5hRJTvicwrCxc9K/view?usp=sharing
Customer Rank: https://drive.google.com/file/d/1biZRd8QKm4r1pnmkImH5chgL_c3pO5bc/view?usp=sharing

Output: https://drive.google.com/file/d/1HpO8a3toPEhBfZRNszHZiejX4DfT35rE/view?usp=sharing

 

Thanks

8 Replies