I have to find the Top 5 Customers for Every Month in a straight table in Qlik Sense. When I create a Pivot table, all the Values show correctly. However, When I convert it into a straight Table, it Sums the values of all the Months and shows the combined top 5 Customers. I want to show the Value Appearing in the Pivot Table in the Straight Table Respectively.
Suppose I select 3 months i.e. Dec, Jan, Feb the pivot table and straight table differ I want the same values to appear in the straight table as they are appearing in the pivot table
I have Attached sample data for better understanding.