Organizing a Pivot Table by current year average revenue and displaying the top 10 clients.
Hello! I'm new to Qliksense and currently involved in migrating from Tableau. I'm looking for a way to sort clients based on their current year average revenue and display the top 10 clients (Bottom 10 client on separate pivot table) accordingly. This needs to be done within a single pivot table that also includes month-by-month revenue data from 2022, 2023, and 2024 year-to-date (YTD).
When I consulted with a Qlik Sense developer on my team, they confirmed that achieving this isn't feasible.
