I have different sort order issues. Let me explain a few:
1) Product Groups on the X and Wholesaler Groups on the Y.
At first the the sort orders are working well with the sort option: Wholesaler Group -> Expression =min[Wholesaler Sortorder] Product Group-> Expression =min[ProductSortorder]
But when you drill down on a wholesaler group the product sort order begins the change, which isn't what I expected. The same goes when I start drill down on a product group the sort order from the wholesalers starting to change.
How can I solve this?
2) I have a simple list box with product types. The product types do have a corresponding sort value. For intance: Cola - 1, Sinas - 2, Beer - 3, etc.
Yet the box is sorting the product types based on the sort order I have presented. I have used Sort -> Expression = min([Product Type Sortorder])
Yet it does something completely random as it seems for me.
