4 Replies Latest reply on Jun 18, 2012 2:13 PM by Alex Kerin

    Show Top 5 for each parent

    Andrew Peterson

      Sorry if this has already been answered but I can't seem to find a solution.  I am trying to get the top 5 items for each department.  My final report would look like:

      Department 1

           Item D     $$

           Item C     $$

           Item G     $$

           Item A     $$

           Item M     $$

      Department 2

           Item 64     $$

           Item 43     $$

           Item 3       $$

           Item 29     $$

           Item 17     $$

       

      And so forth.  The problem is when I select Top 5 items it only gives me the top 5 items in total not for each department  I want the top 5 itmes for each department.

       

      Thanks in advance for any help.

       

      -Andrew