i have a table of EVENTS with PARTICIPANTS and want to get a list of all participants of several events to make a cross-tabulating (who took part where).
For that I started to collect IDs of the events in a field and I use a portal to show all brands of theses events (in mid there is a M;N-relation-table). Works well.
Note I want to export all the shown fields (PARTICIPANT, EVENT) into an CSV-file to open this in Excel and use a pivot table for the cross tabulation.
First question: is there good possibility to do the cross-tabulation in Filemaker /with using virtual lists).
Second question: if not, how can I best export the values as mentioned above?