Ok here's what I need my view to look like.

http://cannareview.ca/medical-conditions-view.png

The bracketed numbers beside the Medical Condition is the number of Products that are referenced to each Medical Condition through the Product Review node.

Let me break down my content types and entity references

Product
Product Review
Medical Condition

Product review has an entity reference to Product and a Entity Reference with Entity Reference Auto Create to Medical Condition so that users can add Medical Conditions that are not listed by default.

This is what is available in my Relationships

  • Entity Reference: Referenced Entity
    A bridge to the Content entity that is referenced via field_producer_product
  • Entity Reference: Referenced Entity
    A bridge to the Content entity that is referenced via field_medical_conditon
  • Entity Reference: Referencing entity
    A bridge to the Content entity that is referencing Content via field_medical_conditon
  • Entity Reference: Referencing entity
    A bridge to the Content entity that is referencing Content via field_producer_product

I've tried many combos but just can't get this to work.