4 Replies Latest reply: Oct 15, 2013 4:06 AM by stéphane hans RSS

    Ten first products in a pivot table

      Hi everybody,

       

         I have some sales data by family product and product. I want to extract and represent in a pivot table the ten first product of each family product.

      In a straight table, it is quite easy with the dimension limits but in a pivot table it is slightly harder.

       

      I tried to filter my 10 first item with a rank but other products are still visible in my straight table.

       

      Have you a idea to remove those with null value in sales ?

       

      I don't understand why there are still shown as suppress missing and suppress zero values are selected.

       

      I join the application example.

       

      regards

      stephane