In this case you have two data sets (for Steve and Karen) in the different sheets of the same excel file. These are the files for which you want to do Tableau blending. What you have to do after opening your excel file in Tableau is to select on of the excel sheets either Karen or Steve. Then you open your Tableau sheet and press Crtl + D for new data source and select other sheet of the Steve_And_Karen excel file. After that you go to your Tableau Sheet1 and what you have to see is this:
This means that your sheet is connected to both sides of spending data for girlfriend and boyfriend.
Now the first action is to drag Sum, Eu measure to the columns field (remember that we are doing it when Karen part of data is selected as it is shown above). After doing this you only see that Karen’s spending total is 1385 Euros. Now in data selection field you see checkmark at the Karen’s data part icon, this means that visualization is coming from this data source:
Secondly, we are dragging Karen’s spending
dimensions to Rows field. Now we can see how she spends money in January, February and March:
Because we don’t see anything about Steve’s expenditure, we have to select his part of database and drag his Sum, Eu
measure to Columns field. Now we see that new right side horizontal bars occurred. The bad thing that we have the same number (1285) for every month and spending type, because it comes from total Steve’s three month expenditures.