I have two tables one an orders table that has 3 master calendars - date entered,date scheduled and date collected. I have a separate table that lists dispatches for which i have generated master calendar for dispatches. The two tables can be plotted as graphs independently but if i want to combine the tables to get:
Tonnes dispatched for a month with tonnes collected for the same month and tonnes entered in the same month.
I have tried using an if statement =sum(if(CollectMonth=DispatchMonth and DispatchYear='2018',[Quantity Collected],Null())) to try and link the numbers form two master calendars.