I got a view to list a content type (Say faculty). Among many fields, I have a field collection (Say position) which got a Designation field (Taxonomy Vocabulary).
Now I need an exposed filter criteria and sort criteria to sort the entire content based on this Designation inside this field collection.
By adding a relationship, I managed to apply the filter using "Designation", But I am unable to sort the content using the weight of this "Designation" taxonomy. Note: Sort by taxonomy name is working. The problem is sorting with the weight of taxonomy.