I have two tables - Table A is detail for books with a start and finish date and Table B is a goals table where it includes the year, a column for the goal of books to read and I want a column that shows the number of books read based on the Year column in Table A. In Table A, there is a column called Year, where I used formula to pull out the year from the Finish date.
All I want is a count of 1 for each line where a book was finished in 2020. Likewise when the year 2021 is added, I want that to only show a count of books read where finish date is 2021 and so on,
Is there a way to do this when two tables are involved?