Hi rajsukh,
SAS Visual Analytics Designer might have another feature that you can use with your revenue figures.
You can rank values to subset your data. For example, using the Rank tab, you could create a rank to display the top 10 stores for revenue. When you apply a rank, you can specify top count, bottom count, top percent, or bottom percent. You can apply a rank to your data item, and then use that data item in a list table.
Here's the related information in the SAS Visual Analytics 7.3 User's Guide: Ranking Values in Reports. (There's similar information for previous releases here: http://support.sas.com/documentation/onlinedoc/va/index.html.)
-Joy
... View more