5 Replies Latest reply: Sep 21, 2011 12:31 PM by Debbie Pyykkonen RSS

    Pivot Table Top 5

      Hi,

      I have a Problem with Pivot Tables to get a Top N List.

      Problemdescription:
      This is only an example: I have a Pivot Table sorted through Sum(Quantity). Now I would like to create a Top 5 List with Pivot Table. I know that I can do this with Straight Tables in the Presentation Tab, but I need it for Pivot Tables.

      Prefered Solution:
      I would like to get a Pivot Table for the Top 5 Product sorted by Sum(Quantity). If it is possible please without Macros.

      For a solution please use my attached .qvw file.

      Thank you for helping me.

      Regards,

      Herbert