Forum Discussion
Measure returning majority category
Hello, I'm trying to categorize my products based on Sales and Cost conditions. Based on the majority of the products category, we are then categorizing the manufacturer. This is...
SabineOussi sure. can you paste your data as a table.
parry2k Here you go
| Manufacturer | Product | Sales | Cost |
| A | A.1 | 100 | 5 |
| A | A.2 | 50 | 10 |
| A | A.3 | 30 | 5 |
| A | A.4 | 20 | 15 |
| A | A.5 | 50 | 20 |
| A | A.6 | 80 | 5 |
| A | A.7 | 10 | 30 |
| B | B.1 | 150 | 15 |
| B | B.2 | 200 | 5 |
| B | B.3 | 80 | 10 |
| B | B.4 | 60 | 10 |
| B | B.5 | 40 | 15 |
| C | C.1 | 50 | 10 |
| C | C.2 | 450 | 45 |
| C | C.3 | 20 | 40 |
| C | C.4 | 30 | 10 |
Thanks,
Sabine O.