topic Top 3 Customers & Rest of all Customers should display as Label With Others in Pivot Table in QlikView

Top 3 Customers & Rest of all Customers should display as Label With Others in Pivot Table

Fri, 17 Feb 2012 05:52:07 GMT

Hi All,

i am having table data as follows

I Want to Display Data in Pivot Table as Top 3 Customer Names and rest of the customers total as Label Others as shown below

Please Help me in resolving the above.

Thanks in Advance.

Chandu

deepakk — Fri, 17 Feb 2012 06:21:19 GMT

hi,

I hope attach application helps.

Deepak

Fri, 17 Feb 2012 06:31:49 GMT

Thanks A lot