How to compare Half-Yearly Sales?

How to compare Half-Yearly Sales?

I had this request from a client to be able to see (let’s say sales) Sales by half-yearly. what made this one trickier, was that the company’s FY starts in July, so the first half of the Fiscal Year 2023 is from July 2022 – December 2022. Which translates to...