https://community.qlik.com/t5/Featured-Members/RANKING-With-Multiple-Column-in-Pivot-Table-Top-10/m-p/2152285#M176 <P>Hi I have this kind of data set I just need to show the top 5 based on amount ranking.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KevinJ_0-1702441670195.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/125300i70CCB68ED76B8150/image-size/medium?v=v2&amp;px=400" role="button" title="KevinJ_0-1702441670195.png" alt="KevinJ_0-1702441670195.png" /></span></P> <P>&nbsp;</P> Wed, 13 Dec 2023 04:28:30 GMT KevinJ 2023-12-13T04:28:30Z https://community.qlik.com/t5/Featured-Members/RANKING-With-Multiple-Column-in-Pivot-Table-Top-10/m-p/2152285#M176 <P>Hi I have this kind of data set I just need to show the top 5 based on amount ranking.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KevinJ_0-1702441670195.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/125300i70CCB68ED76B8150/image-size/medium?v=v2&amp;px=400" role="button" title="KevinJ_0-1702441670195.png" alt="KevinJ_0-1702441670195.png" /></span></P> <P>&nbsp;</P> Wed, 13 Dec 2023 04:28:30 GMT https://community.qlik.com/t5/Featured-Members/RANKING-With-Multiple-Column-in-Pivot-Table-Top-10/m-p/2152285#M176 KevinJ 2023-12-13T04:28:30Z https://community.qlik.com/t5/Featured-Members/RANKING-With-Multiple-Column-in-Pivot-Table-Top-10/m-p/2152335#M178 <P>In your table columns, you will find "limitation" option. Select "fixed number" under that dropdown and choose top 5,10,15 any number you want.</P> <P>Regards,</P> <P>Aditya</P> Wed, 13 Dec 2023 07:26:37 GMT https://community.qlik.com/t5/Featured-Members/RANKING-With-Multiple-Column-in-Pivot-Table-Top-10/m-p/2152335#M178 Aditya_Chitale 2023-12-13T07:26:37Z