Once you have the blend working, you could create a calculated field in the actuals data source that checks whether the given date has an actual amount, and if so, then use the projection from the projections data source instead.
It's hard to suggest a more definitive solution without data. If you need more help, please post a packaged workbook with sample data.
Thanks for the response,
I have attached a packaged workbook. The difference bar sheet is what really shows what I am talking about. I don't want to only show actuals, I want to show how our actuals compare to our projections. If we don't have an actual, I don't want it to show a projection data point either.
Thanks for any help provided.
Milk Projections.twbx.zip 673.3 KB