Skip to main content

I am a Tableau 10.5 desktop user trying to blend data to create a dual axis chart, and I am having problems. 

 

Sheet 1 is for Collections.  Sheet 2 is for Expenses.  I would like one chart that has a Collections and Expense bar for each month.

 

Data Blending Problems   Screen+shot+1.jpg

 

Data source is linked on Month/Year field          screen+shot+3.jpg

 

On my collections chart I bring Expenses into the view as a secondary data source.  Expenses displays the grand total amount across each month instead of the correct monthly total.

 

screen+shot+4.jpg

 

What am I doing wrong here?

3 answers
0/9000