How can I use aggregation Lookup?
Link (Lookup) Count:
To lookup the count of the data here is the process:
- Create a column
- Double-click or right click on the header to change the column property
- Rename the column with an appropriate title and go to the drop down menu
- Select Look Up Count from the list
- Select link column to do lookup count upon (it will show you all the columns that have been linked)
- Apply and it is done
- The data will bring you a number of the linked rows.