Sales targets are monthly by region while actual sales are daily by store. Which design best supports trustworthy comparisons?

1. Hide the target column from the dashboard prompt
2. Convert target amounts to text before joining
3. Declare appropriate logical levels and aggregate actuals to compatible dimensions
4. Join targets to every sale and sum target values