OK, so I have my product in Drupal Commerce basically sorted by two major taxonomies - Sport and Product Category.
What I want to do is set up a view that prints out the available product categories for a particular sport (i.e. if a product has a particular sport associated with it, then sort through that list and find what product categories are available for that sport).
I have the view somewhat figured out - but it keeps giving me repeats of the product category, where I only want a particular product category name to show up once.
For instance, if I search for the sport 'Football' - I get a list that looks like this: - Balls & Tees - Shirts - Balls & Tees - Balls & Tees - Pads - Shirts - Shoes etc. . .
What I want is for those duplicates to be removed (so Balls & Tees only show up once).
In my current view, I have it set up to return fields of content - with the Taxonomy name of Product Category as my only field.
I have a conditional filter of the parameter set.
I do have a relationship set of Content: Taxonomy terms on node.
I tried using aggregation DISTINCT option, but that doesn't seem to help.
I have looked through this topic -https://drupal.org/node/1200536#comment-4957410 - but I am not sure if its related or not.