bar or combo chart help

[qvqfqlik]

I am trying to create a bar chart or a combo chart

for a certain date

on x-axis I will have to show customer name from table1, if there is a match for number

else , if there is no match for a number, I will have to show only the number from table2.

on y-axis I need to show by timeperiod  and dollars. I have attached spreadsheet to my post.

please help with this.

[vishsaggi]

What is your measure here? Can you share some expected output here or a snapshot of it?