In the product views of my drupal commerce site, I want to list the products sorted by amount(price).
The product has 4 categories. They are added as relationships in the view:
Now to sort them by price, I am doing the following:
This is working perfectly fine in another view where I am using Contextual filters(Product category).
But in this view, where I am displaying products of all categories, the sorting is not working. What is happening in this case is:
First all the Poultry items are coming in sorted(by price) order.
Then all the Fish items in sorted(by price) order.
And so on.
What I want is :
All Items should be collectively sorted by price.