1 Reply Latest reply: Jul 17, 2017 5:45 AM by Konstantinos Mertzianis RSS

    Limit Pivot Table Data in QlikSense

    Allan Thomas

      Hello,

       

      I have a Pivot Table with 3 Line dimension, 1 column dimension and 2 measures.

      The line dimensions are :

      1. Customer Family
      2. Customer Name
      3. Product Name

       

      The measures are :

      1. Sum(Sales)
      2. Sum(Margin)

       

      I put a relative value limitation of >= 20% on the dimension "Customer Name"  and check the "Show others"

       

      Capture 1.PNG

       

      How to group all the product below Customer "Others", without grouping the products the other customers for example "Galec"


      Thanks for your help