2 Replies Latest reply on Apr 2, 2013 8:22 AM by Marcelo Konatu

    Tableu 7 - Using top to restrict the number of records

    Marcelo Konatu



      I am trying to create a report that returns the top 10 products of a given product category; I though I could use TOP FILTER but when I do that it grabs the 10 products of all categories.


      I have an attached example that shows a report being created with a quick filter on the Category field and a filter in the product name with TOP used to bring the 10 products with the largest amount of sale. In this example I get 1 product from from Furniture, 1 from Office Supplies and 8 from Technology.


      I would like to receive 10 of each category. Is there a way to accomplish this?