Hi, QlikView community
I have an easy data that has category for my companies (fish, food and machinery), Comapny then year and income
An example in the data look like this
| Category | Company | Year | Income |
| Fish | Seafood | 2016 | 1.532.545,78 |
| Machinery | Cars Inc. | 2016 | 374.290,77 |
| Machinery | Machinery Inc. | 2016 | 108.202,71 |
My problem is when I want to get sort order in my table.
I have sorted the companies after the biggest income (sum(income)).
But problem is when a do that is the companies that are big in many categories are always first.
But I want the category to be alphabetical order and then I want to have sort order after category and biggest income.
So I want the order for Fish to be the biggest in that category is first and then down the list:
1. Seafood
2. Fresh Food
3, Frozen Seafood
5. Frozen Food Inc.
| Category | Company | =sum(Income) |
| Fish | Seafood | 1.586.083 |
| Fish | Frozen Seafood | 49.767 |
| Fish | Fresh Food | 54.499 |
| Fish | Frozen Food Inc | 454 |
| Food | Frozen Seafood | 500.000 |
| Food | Candy Inc. | 2 |
| Machinery | Cars Inc. | 376.647 |
| Machinery | Machinery Inc. | 111.400 |
regards Darru
