I am working in Drupal 7 and I have two content types: "member charity" and "member news story." "member news story" contains a "field_charity_reference" field (a node reference) that creates a reference between the news story and the member charity the story is about. I wish to set up a view that shows all the news stories for any charity. I have set up a page view with the path /our-members/news/%. I can set a relationship on "Content: Charity Reference" that filters only nodes with a charity reference.
How do I pass the charity name from the URL, so that only "member news story" nodes with a node reference to the charity name are returned?
Note: I have tried using "content: NID" as a contextual filter, setting the relationship to "field_charity_reference" and "When the filter value is not in the url" set to provide a default value, type Raw value from URL, path component 3 and ticking "use path alias." I have also tried the above using "Content: Charity Reference," but neither of these return any results when I go to /our-members/news/example-charity-name.