How to pull from related table RRS feed

  • Question

  • Hello. I have a lookup table with customers. In a related table I have a bunch of categories connected to those customer ids. I want to count a certain occurrence in one column for EACH customer, GIVEN the condition that another column in the non-lookup table is a certain occurrence. 

    For example count Column Paid Invoices = Free for each customer in the lookup table, GIVEN the additional condition (in the non-lookup table that another column called Status = Active. 


    Saturday, September 24, 2016 11:36 AM


  • Hi AlexMartini,

    Based on your description, I am trying to reproduce your issue in my local computer using the following three sample linked tables.

    I calculated the count for each custom in Table Custom and get the excepted results. Then get the count based on the Values is “Yes” in another column of non-lookup table Table3 as follows.

    If this is not what you want, please give us more details and sample data structure.


    Monday, September 26, 2016 7:20 AM