I am trying to create a calculated field that will combine total number of new hire employees based on their date of hire. The data will have to come form two separate data sources with similar data. One has current employees and one has employees that have been terminated, but need to be included in the count of employees hired for each year. I will also need to filter by year (from both data sources) I have tried this: But get the following message:
Any ideas would be appreciated. I am somewhat of a novice, so please keep that in mind!
Hi Wendy,
Looks like you're blending data, not joining...personally not a fan of it unless it's the only method of bringing two sets of data together...it's too limiting and automatically a left-join. So, I would be joining the data sets together in the Data Source Tab, not blending. But, if you're committed to blending, then you need to go to Menu-->Data-->Edit Blend Relationships and create the 'join' there.
You'll get a new dialog box where you align/match/map the two datasets together on a common field(s). Best, Don
