1 Reply Latest reply: Apr 29, 2009 5:22 PM by Neil Miller RSS

    Newbie Question. . .

    gdivay

      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,

        • Newbie Question. . .
          Neil Miller

          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.