Limit Pivot Table Data in QlikSense

[Anonymous]

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"

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

Thanks for your help

[kmn]

Hi Allan,

Not quite sure if I understood what you want to achieve but take a look at the attached .qvf.

-K.