Sorry in my previous text I made a mistake. It should be "as July" and not "and July".

First of all, it would have been more helpful if you had...

First of all, it would have been more helpful if you had added a few rows of data in your example. However, if you want a pivot kind of report/output,...