7 Replies Latest reply: Feb 6, 2013 10:50 AM by Kirti Sheth RSS

    Top N in Pivot table with 2 or more dimensions

    Dinesh Kumar

      Hi all and hope everyone is good.

      I have this issue with Pivot table where I have to list top 5 Products (based on sales) with 2 dimensions. It works good with one dimension but when I add two dimenstion, I am getting all the products and not just the top 5. See below pic for the desired layout. I know that I have to restrict my dimensions using RANK and AGGR functions so that only top products are shown but this is not working for me. Any suggestions/ideas? Thanks for your help.

       

      Pivot table issue.jpg