Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.