How to isolate the sales for a single state for a given year

This might not be directly what you are looking for but I know many people who swear by using this software as a bridge between their shopify account and their tax software

https://linkmybooks.com?fpr=trusted-brands-direct