Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor III

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

hi,

I hope attach application helps.

Deepak

2 Replies
deepakk
Valued Contributor III

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

hi,

I hope attach application helps.

Deepak

Not applicable

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

Thanks A lot

Community Browser