The revenue query filtered by invoice_items.branch_id which doesn't
exist, causing 0 results when a branch is selected. Use
payments.branch_id directly since payments already track their branch.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>