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:
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 ...