Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

Hi All,

i am having table data as follows

CustomerAmt
a8
a10
b20
c7
d10
e15
f12
f20

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

CustomerAmt
f32
b20
a18
Others32
Total102

Please Help me in resolving the above.

Thanks in Advance.

Chandu

1 Solution

Accepted Solutions
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

I hope attach application helps.

Deepak

View solution in original post

2 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

I hope attach application helps.

Deepak

Not applicable
Author

Thanks A lot