0 Replies Latest reply: May 3, 2013 4:26 PM by 1007023 RSS

    Help with Displaying top 5 items but not change segment totals with Conditi

    1007023
      I am trying to create a report for a customer that has the following levels of row dimension:

      Stores
      Category
      Item

      There are several stores, categories, and items in the report

      I would like to display only the top 5 Items in the report but not have the system recalculate the totals for the truncated set. I placed a condition that makes a ranking <= 5, but the totals displayed change to total up to the limited returns. Is there a way to make the total lines static, non-changing, so that I can display top 5 but still have the category total? Thanks.