I don't know why Intuit doesn't offer this but the only way we've been able to accomplish this (and more) is to sync the data with a database with something like Skyvia.com and run our queries/reports from there.  Or you can use that to export to CSV, import to Excel or Sheets, do a bit of formula work to lookup states in one sheet to update, say, an invoice row in another, then use a pivot table to summarize invoice amount by state.  Not ideal at all for people who don't have technical resources but there is a way.  Invest in these skills and you'll be glad you did.