Create Aggregate Columns on custom lists
i would like to create a column/field (totalB) in a sharepoint custom list (List A) that counts items from another list (List B).
ListA has a field that is a lookup column from ListB. So, i would like to display the total number of items of list B that are connected with List A.
I don't know why such a simple task could be so trivial in sharepoint.
The constraints are:
- the column is computed
- it has to be encapsulated in the allitems view so all other views could inherit this column.
Thanks in advance,