I’m extremely new to filemaker and struggling to complete a layout that my supervisor needs.
We work at a theater and are building a database of past budget numbers. There’s a number of variables including:
Fiscal Year, Department, Account, Project, and Amount Spent.
Ideally, we’d like to have a malleable line graph where you have a dropdown find menu to select the department (or all), the account (or all), the project (or all). Additionally, we’d like the option to set a start year and end year for the search, or leave it blank to get all years available.
How do I get these find options and get them in layout? How do I make the “All” of each a searchable option so only one point/amount totaled comes up for each year instead of one point for each department, account, project, etc?
Is this possible? How?
Again, I'm very new to filemaker (this is my first big project) so the simplest responses/solutions would be much appreciated.