Use this Filter
Drag it to Filter and Take out Others
Thank you Deepak - this filter works great to remove Others while maintaining the correct Total Market sum. I am still having the problem when I try to apply a top 5 filter, the grand total only shows the sum of the top 5 vendors now. I need the total market sum to show all the vendors even though the table is only displaying top 5. My approach is filtering on the vendor dimension - is there something different I can do to see only top 5?
I avoided the filtering of underlying data by this filter. I think you also want that. Now in this situation what you can do is create another sheet for grand total and put these together in a dashboard. your grandtotal needs to be static irrespective of filter so I think it will work.