NAV 2016 - Interactive Sorting a Matrix

Fr0mi

Hello,

I am trying to implement interactive sorting in one of my reports which is using a matrix to display the dataset.
The difficulty lies with getting the interactive sorting to sort the following way:

Let's recreate the example to follow along..
- Row: Customer
- Column: Month
- Primary Key: Customers, Month
- Every customer has exactly one entry: "Sales" per month in the dataset

- Rows are grouped by CustomerCode
- Columns are grouped by Month

Now, the aim of this is the following: I want to sort the Group Customers by their respective Sales specific to one Month.

Is something like this possible?
If needed I can supply an example with pictures.

Thanks in advance!