4 Replies Latest reply: Jan 28, 2014 12:47 AM by Tresesco B RSS

    Limit dimension in pivot table

      Hello.

       

      Does anyone know how to limit the display of one dimension in a pivot table to first 10 items ?

       

      For instance, I want to display only the 10 most important countries in terms of measure in the pivot table below ?
      Is this possible?

       

      Thank you very much.

       


































       

      Institute


       

       

      Country


       

       

      FRANCE


       

       

      ETATS-UNIS


       

       

      ALLEMAGNE


       

       

      ROYAUME-UNI


       

       

      ITALIE


       

       

      ESPAGNE


       

       

      CANADA


       

       

      SUISSE


       

       

      BELGIQUE


       

       

      PAYS-BAS


       

       

      CHINE


       

       

      JAPON


       

       

      SUÈDE


       

       

      P150


       

       

       


       

       

      40000


       

       

      6000


       

       

      4000


       

       

      3500


       

       

      3000


       

       

      2500


       

       

      2000


       

       

      1950


       

       

      1900


       

       

      1850


       

       

      1350


       

       

      1200


       

       

      1100