For the purposes of this article, I'm going to assume a direct relationship exists between your customers table and the table containing transaction / sales / orders data.
Start by locating the specific customer you're interested in.
Now, there are two ways you can look up the sales associated with this customer:
Click the drill down arrow to the left of the table.
Trevor will show you all the tables your customer table is connected to, which should hopefully include the table containing sales / transactions data.
Want to dig in? Just click the Open results in new tab button.
(2) Join in the data
- Click the Join button above the table.
- Click the sales / transaction table
- Hit Done.
Trevor will connect the two tables together.
We're on standby to help! To chat with us, click the blue Intercom button in the bottom right of Trevor.io.