I figured it out. I used nested Set Analysis to only rank the top 5 Products, basically ignoring the calculated dimension. I forget the power of set analysis sometimes.
Hope this example helps somebody. Just a note, I also added the rank expression below to my SORT expression so that the calculated dimension "Others" would show up last like it does in a regular straight table.
Example.qvw 123.2 K