First of all, I think you'd better use union instead of blend considering
- need to eliminate null date
- file format is similar.
And need to prepare several layers of table calc.
Example_makeupactual_SM_18.1.twbx 237.1 KB
Thanks for your response to this.
This does in fact work, however in my case the data with actuals are in Salesforce and the targets are in an Excel spreadsheet. How am I to create a union?