Summaries based on values in Text field
I have a small tourism rental and manage my bookings in FM11. I want to use the data to learn more about what advertising works and what not, as well as comparing year to year.
The interesting Table here is Bookings, which among others have the fields Price and Source. (Source is where the booking comes from, entered from a Value List)
To start with I would like to list Income (sPrice) and number of bookings for each value of Source, preferably sorted descending. If I manage that I hav a few more ideas...
Can someone point me in the right direction?