Relation

[Ahmad_H]

Hello,

I have 2 Excel sheets, the first sheet named"Zom", teh secind sheet named "San"

the first has these  columns :

teh second sheet has these columns: 

- How can I create a chart shows the number of baskets have been distributed in both villages ( both villages in the same chart)?

I dont know how to create relations.

can any one help me with teh relations, please?

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, append both tables to create a single one.  Now create your visual.

[Ahmad_H]

Thank you @Ashish_Mathur  it worked well.