How to display data from two tables (one table created using query editor)
Kindly seeking your help to solve below issue.
I need to display actual sales vs. target daily. Actual sales are extracted from the "Sales" table & another table for "Target" which is created using the query editor (which is not visible in the merge/append options for your information).
Two tables are connected with 'Date' as a table relationship.
Date Sales Sales Rep
1-1-2019 100 David
1-2-2019 200 James
Date target Sales Rep
1-1-2019 150 James
1-2-2019 200 Flinch
Now I need to see Daily actual sales vs. target on the same chart and also a "Sales rep" as a filter option.
I was searching many threads but still couldn't find an exact solution for this.