I have a simple table which includes seller, buyer, transaction date, and total.
I want to sum the transactions for each seller by quarters over a given year. The quarters begin on June 1 and end on May 31.
I know how to sum by the seller for a given date range, but can't figure out how to do it for multiple quarters.
I would like for it to look like
Seller Q1Total Q2Total Q3Total Q4Total
Seems like something that should be fairly simple but I'm struggling to figure it out.</div