0 Replies Latest reply on Feb 12, 2013 12:08 AM by manoj nair

    Calculation of rank based on Product

    manoj nair



      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.