Have a view in which i have the top Products (according to sales 2012) in descending order. the products can have multiple companies and the companies are rolled up to "All Others" incase the Sales for the company for that product is less than "$100,000". Now i need to display a rank for the Products on a Product level alone. Hence a product will have a rank say "1" in spite of how many companies/rows it has. Right now the rank cannot be calculated because the AGG(Corp) exists (which is a calulated field). PFA tableau workbook for more understanding. hope i was clear and brief.