Forum Discussion
Solved
Create report from from two tables
I want to create a report that will show gross sales (budget) vs. actual sales. For some reason, the report generated repeats actual sales data every month. Here's my dummy sample report. I'm also ne...
Ice1341 Seems like there is no relationshipt built between the two tables.
And looking at the samlple data, Cust Code from Sales Budget should be joined with JF Code in Sales Invoice data which should resolve the issue.
Create a calendar Table and join dates from both table
Yes, build relationships of both the tables from Calendar table and in your chart you can just used the date fied from Calendar table.
I found a workaround that filtered dates into my report correctly. Thanks everyone for your help!