Hello there, crat.
It's nice to have you here in the Community. It's my pleasure to assist you today.
You can pull the Custom Transaction Detail report and add the Name State column however it cannot be totaled by State. You'll need to export this to excel and sort it from there.
While this option is unavailable, I encourage you sending this idea straight to our developers through feedback for future developments. I'll make sure to do the same thing on my end.
You can send your product suggestion through this link: QuickBooks Desktop for Mac Feedback.
Please let me know if there's anything else I can help you with. I'm always here to further assist.