Forum Discussion

Joseph1's avatar
Joseph1
Regular Visitor
3 years ago

Dynamic TOP 10/others matrix

Hello, 

 

I need to create two groups in a matrix: TOP 10 and others. My data looks like:

 

DescriptionAmount
A10
A20
B30
B40
B50
C60
C70
C80
C90
D100
D110
D120
D130
D140
E5

 

In this case, I would need the following result: 

 

Description2Amount
D600
C300
B120
OTHERS35

 

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!