Calculate publications for a given author

#1

Hi, I am a beginner user. I created a table with a list of publications and their authors. One publication often has many authors and publications are marked as international or local. At the moment, one row contains columns of authors, the name of the publication and the type of publication. I would like to create a table where for a given author the number of publications of a given type will be assigned. Thank you for suggestions.

#2

Hi @Przemek_Sawicki - thanks for sharing your doc with me. Replying here too in case it helps others.
[Publications].Filter([Author].contains(thisRow.Author) AND Type=“Internatonal” AND Year=2018).Count()