So I have two repeating tables, one with a list of names, the other with a drop down list picker (that gets its choices from the list of names) as well as an error message(defect, error, suggestion). Somewhere else on the form, I want a summarizing repeating table that counts the number of names in a certain category but also shows the names from the first list.
So the first table is like:
App1
App 2
App3
The second table:
App 1: 1 error + description
App1: 1 defect + description
App 2: 1 error...
Summarizing Table
App 1: 1 error, 1 defect, 0 suggestions
App 2: 1 error, 0 defect, 0 suggestions
App3: 0, 0,0
I can't figure a way to get the count to be like count(Category[errortype ="defect" and ../Name (from second table) = appname(from first table))