From your description, it sounds like you are finding the top 10 commodities by using the filter. Using the filter will exclude the rest of your data. However, by using the index() function, you may be able to get the desired results. Create a calculated field similar to the following:
Place this on the filter shelf and check True. Since this is a table calculation, you'll want to make sure that it is correctly being computed (right click on the calculation on the filter shelf and select Compute Using).
Hope this helps!
Thanks so much for your help! The trick worked. But, my problem still lingers as I have an additional layer of information that I display using the color shelf. For example, lets say that I use a category variable which groups goods in two classes - Luxury and Normal. I then use this category variable in the color shelf. When I do that, the trick you showed above loses its merit and I cannot display the way I want to. But, if I do not use the category variable in the color shelf then your trick works wonderfully well!
Is there a way to use both the color and the top X with the correct percentages displayed as labels?
Many thanks for your help.
Adding a different dimension to the color shelf makes for more complex view. Depending on the specific outcome, the following KB article may be able to shed some light: