Use fields from related modules in view columns and filters

Use fields from related modules in view columns and filters

I need to be able to add filters/fields that are belonging to a related module to a view. It would be even better it could pass through more than one relationship.

Example: I want to build a view for my Contacts, whose Accounts' Ownership is Private, returning the fowllowing fields:
  • First Name (Contact)
  • Last Name (Contact)
  • Website (Account)
Example 2: i want to build a view for my Contacts, having Accounts with Deals on stage Closed Won