I got a request this week from our customer service group that stumped me.
We use person-account, case, and a custom object called order (that person bought something). Both case and order have lookup to account.
They wanted to see accounts with orders that had cases of a certain type. It looked like report types offered vertical relationships (contact to account) but not a V-shaped 3-Object option.
Thoughts? I'll admit I haven't dived into joined reports, but would if someone told me this would work.