Hello,
i have a problem with sorting my data in saiku Analytics plugin.

I have customers (dimension) with sales orders (count measure) in the years (dimension) 2015, 2016, 2017
I want to show the count of orders with the customers in rows and the year in columns as a matrix.
I want to sort the customers descending by sales orders.

Without any filters I get something like this:
Customer/Year 2015 2016 2017
B 20 5 60

A 5 30 2

C 1 2 5



That's correct. The customers are sorted by their orders as the complete sum over all 3 years.

Now, I want to filter the year, so that i only see the year 2016.

I also want to sort the customers by sales orders descending.



Then I get someting like this:

Customer 2016

B 5

A 30

C 2



The sorting order stays the same.The customers are still sorted by the sum over all orders per customer.

It doesn't matter which year or how many years i have filtered and want to Show.


It's the same problem with all dimensions if they stay in the columns.
If i want to filter a dimension placed in columns i get a false sorting order.

If the year is also in rows, the sorting works fine.
Can anyone help? It's a bug oder can it be a problem in my mondrian schema?

Thanks a lot ...