https://community.qlik.com/t5/App-Development/Test-for-Pivot-and-Straight-Table/m-p/1541089#M40332 <P>Hello Everyone,</P><P>I have to find the Top 5 Customers for Every Month in a straight table in Qlik Sense.<BR />When I create a Pivot table, all the Values show correctly.<BR />However, When I convert it into a straight Table, it Sums the values of all the Months and shows the combined top 5 Customers.<BR />I want to show the Value Appearing in the Pivot Table in the Straight Table Respectively.</P><P>i.e.&nbsp;</P><P>Suppose I select 3 months i.e. Dec, Jan, Feb the pivot table and straight table differ<BR />I want the same values to appear in the straight table as they are appearing in the pivot table</P><P>I have Attached sample data for better understanding.</P><P>Thanks</P> Sat, 16 Nov 2024 06:38:50 GMT satish25 2024-11-16T06:38:50Z https://community.qlik.com/t5/App-Development/Test-for-Pivot-and-Straight-Table/m-p/1541089#M40332 <P>Hello Everyone,</P><P>I have to find the Top 5 Customers for Every Month in a straight table in Qlik Sense.<BR />When I create a Pivot table, all the Values show correctly.<BR />However, When I convert it into a straight Table, it Sums the values of all the Months and shows the combined top 5 Customers.<BR />I want to show the Value Appearing in the Pivot Table in the Straight Table Respectively.</P><P>i.e.&nbsp;</P><P>Suppose I select 3 months i.e. Dec, Jan, Feb the pivot table and straight table differ<BR />I want the same values to appear in the straight table as they are appearing in the pivot table</P><P>I have Attached sample data for better understanding.</P><P>Thanks</P> Sat, 16 Nov 2024 06:38:50 GMT https://community.qlik.com/t5/App-Development/Test-for-Pivot-and-Straight-Table/m-p/1541089#M40332 satish25 2024-11-16T06:38:50Z