Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator III
‎2018-07-30 06:36 AM

Pivot table - Sort data on multiple dimensions

Hello All,

I am creating a pivot table to show the top 10 customers by their sales value. To filter the customers using calculated dimension.

But i need to sort the top customers by their sales based on company and division.  The data should be sorted for each division within the company. I have attached screenshot of the output expected.

Please let me know how to achieve the same.

Thank you.

Regards,

Viresh

Capture.PNG

865 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2018-07-31 08:58 AM

How about this?

Aggr(Sum(Sales), (Division, (NUMERIC)))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
826 Views
0 Likes