Learn how to combine ranking, filtering, and sorting to a report.

Add a ranking to find the bottom 8 selling products at the Product level that have sold more than 250 units in Q3 2022:

  1. Display the Product Categories Hierarchy Editor dialog
  2. Select the Rank result icon on the Advanced Selections tab to display the Edit Ranking dialog.
  3. Select the Bottom radio button, and type 8 into the edit field.
  4. Select 2022, Quarter 3 for the Date.Calendar hierarchy in the grid below:
  5. Run the grid. Only the lowest 8 members are returned.