Targets and date dimension

[#1]

Hi there,

I'm hoping to get some tips on the best way to utilize targets in qlikview. I have a standard data model loaded into a document, with two date dimensions based on sale order date and invoice date. I have targets for each month for different customer types. I have joined this to the invoice date dimension table. This joins on invoice date, and target date value is always tenth of the month because this is a safe day where the value will always be in that calander month's financial month (1st of month can fall into previous month's financial month)

What is the best way to link my customer grouping to a monthly target? Linking in the method above means that if no billing took place on that given day in for that customer group in the fact table, then the target does not pull through. I cant join on a month-year value because this would duplicate my target values by the matching number of fields in the date dimension (I'm assuming that would happen as it happens in SQL obviously)

[#2]

Should I be linking to customer table?

[#3]

Slim pickings on here today, huh?