Payee transaction report by category

For the first issue, have you looked at Transaction Tracker? It lets you slice and dice your transactions just about however you’d like.

On the second issue, not sure I’ve seen a solution for that.