Seems like a simple problem but one I can't get around at the moment!
I am bringing in Sales Rep targets from spreadsheet and actual sales transactions from an ERP system.
I have derived a key which is made up of the month and the rep name in order to link the actual data to the target. So, the actual data contains the month, the rep name and the key plus other data, whereas the target spreadsheet just contains the key and the target.
This works perfectly well when there is actual sales data, but in a month where there is no sales data (for example, in future months), the target is not being displayed in any visualisations. I guess this is because there is no key to join the target to (see attached screenshot).
What is the best way to handle this i.e. to get the targets loaded for months where there is no actual data?
