Please have a look at the file attached for a solution.
I believe you need a claulated dimension like below:
aggr(if((rank(sum( Sales)))<=5,Department,'All Others'),Department)
Best of luck!
test1.qvw 136.0 K
You can use sort on total as descending order removing sort on all other dimension and promote total to top.now restrict max no. in prestentation tab to 6.after that go to dimension limit tab, check on limits box where you can restrict your top 5 values as largest.below that check on show other option.total of all other can be displayed using this option.This dimension limit option is available in qlikview 11 only.