See the last entries by rank as "Other"

I'm working with big numbered "legend" dimensions
Like 133 Agents or 1030 items models.
I'd need to be able to show the first X by ranking and then group the others as "Other".
For now the only way i found was by adding a column but that is static solution. I'd like to be able to make a pie with first x items and one "other" that is responsive to filters like nation or date or client etc..
I can't see a way out except by let the visual handle it but for now they can't