i have a clients table and a transactions table.
The client can also have partners attached to it. However both client and partner can have transactions.
Just trying to understand what is the best way to relate the 2 tables to calculate the client and partner revenue together?
Would it be advisable not to link them together and instead use COUNTROWS based on the specific columns? i.e-calculate client partner separately with variables?