Newbie Question. . .

[#1]

Hello world,

I have two tables ..... Invoices and Dealers both containing a dealer field.

My problem is that i have several countries in my Invoices table and I would like to get the data only about a single country. The Dealers table is containing the necessary data about the country but once my chart is created I still get the data related to others dealers saved in the Invoices table.

Do you have a solution?

Thanks,

[#2]

Set analysis should be able to handle this.

In your chart expression, use something like:

Sum( {<Country={Canada}>} Sales)

Country would be the name of your country field. See the reference manual (and this forum) for more details on Set Analysis.