Please can you advise me on this, still not figuring why i am getting blanks.
The function works fine as I m getting the correct total for 2014 Sales. However I have blanks.??
Not sure by looking at this. I’ve completed a good review but can’t see the issue directly.
Would have to see a file and test a few things.
I believe actually it’s to do with the VALUES( Order breakdown[product name] )
This can’t be joined to the months table as there is no way to filter a sales results concurrently between these two.
Try using the months column from the dates table instead.
Okay thanks will look into this…