Total Sales YTD by Customer

Interesting, but how do you have them as available tables in your first screen shot?
image

OK,
Figured it out. The Top level SubQuery did not have any tables or SubQueries in it.

Another infamous Epicor error message, go left (Well I really mean go Right)

3 Likes

Phocas EDA does this?

Yes it does, basically EDA is a DB query extraction data meaning that you can create any query to extract data from any SQL database, txt, and MS Excel files; then push it to the EDA Cloud service and then create reports/KPI’s from that.