I have 3 lookups. 1 is primary users and a count of total users, 2 is primary users and a task, 3 is primary users and not doing task.
I tried to combine their data using stats count to get the data and appendcols to format into a table. I get the data in a table, but the data from lookups 2 and 3 do not line up with the correct primary user. If I have 15 primary users and 10 with a count, then the 10 counts just start at the top and go down 10. I need the 10 counts to line up with the 10 primary users they are associated with.
... View more