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.