I would like to get a sum of a particular data, however there is a problem is that my raw data may have missing data for it.
Month 1 -> 10k 2 -> 20K 3 -> 30K
In this case the sum of all 3 months should be 60k. However what happens is my data which I need it to use as a comparison to the above data to gauge a person performance, may not have any transaction in the first month thus it will only sum up those months with data how do I get it to sum all data?
Please see below screenshot(This is only a dummy example but it mirrors my actual raw data the same way).
So lets sat the actual expected sales as of Oct is $550,000 however, as my raw data may have conditions whereby there is no sales for certain month, even after creating a relationship to link the month, my actual expected GP is not $550, 000 but $290,000. This way I am unable to check the particular store sales for YTD, as I would like to see my store actual sales vs expected sales for both MTD and YTD. However, it is only currently working for MTD, my YTD is not showing up correctly.