Forum Discussion
Joseph1
3 years agoRegular Visitor
Dynamic TOP 10/others matrix
Hello,
I need to create two groups in a matrix: TOP 10 and others. My data looks like:
| Description | Amount |
| A | 10 |
| A | 20 |
| B | 30 |
| B | 40 |
| B | 50 |
| C | 60 |
| C | 70 |
| C | 80 |
| C | 90 |
| D | 100 |
| D | 110 |
| D | 120 |
| D | 130 |
| D | 140 |
| E | 5 |
In this case, I would need the following result:
| Description2 | Amount |
| D | 600 |
| C | 300 |
| B | 120 |
| OTHERS | 35 |
The solution needs to be dynamic, there's filters that will be applied to the matrix.
I've read multiple threads regarding similar Issues, trying to use RANKX and SUMX functions but I'm not able to solve it when I apply filters.
Thanks!
2 Replies
- PadycosmosSolution Sage
- Joseph1Regular Visitor
Thanks padycosmos. I haven't figured out yet how to solve the issue. Any help would be appreciated.