Count of Gifts Month to date/year to date

Hi there,

I've been chewing on this longer that I'll admit and thought I should finally ask for some help.

In Analytics I am trying to make a pivot table that shows the month to date count and sum amount of gifts for this fiscal year and last fiscal year, split by gift amount range. I would like to use this for reporting on Community Giving and for Memberships.

In my mind it would look something like this:

Sorry the screenshot is so shrimpy. Along the very top is "FY23 Month to date" and "FY22 Month to date". The next row is count and amount for each of those fiscal years. And along the left is the spread of gift ranges: $1-99, $100-499, etc. 

If you can read the numbers on here, you might notice they're kind of funny. The thing that's messing it up the most is that giving range on the left, it's not doing what I hoped it was doing. I had hoped it would relate to the gifts received, for example: In FY23 this month we received 21 gifts that were between $0 and $99, 50 that were between $100 and $499... and so on. Instead what it's doing is showing me how many gifts I received in FY23 this month, and how many of the donors have a lifetime giving amount between $0-99, lifetime giving amount of $100-499 and so on. 

I've tried to get at this several ways but nothing really suits, and the closest I can get would need to be manually updated each month. I would rather make something that is self-managing. 

Can anyone help point me in the right direction?

Jenny