And it worked initially when only a specific month was selected. But when I want to view all of the months together as a years view, the data returns the same amount of each month, rather than calculating different amount like its meant to.
Here is the results I am getting for the year view of Jan and Feb:
When actually it should be showing these results:
I think its a subtotal of the whole year but displaying it on every month? Not sure why some have 0 though. Any ideas?