While creating reports, sometimes you may need to merge data from separate tables, in order to get the complete picture.
In Analytics Plus, you can use the 'lookup column' and combine data across two related tables in your database. It's that simple, and definitely
easier than writing multiple SQL queries to join tables.
While using the lookup function, just make sure that the parent lookup column has unique, non-repetitive values.