Dynamic TOP 10/others matrix

[Joseph1]

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!

[Joseph1]

Thanks padycosmos. I haven't figured out yet how to solve the issue. Any help would be appreciated. 

[Padycosmos]

Hope the video in the link would help :

https://www.youtube.com/watch?v=tgL7D3JTa_E