Simple newbie question - setting up function/tables for diff quarters

[hizzle]

WARNING WARNING! DANGER NEW FM USER ALERT!

So I have taken just an Intro and Intermediate FM class, and quickly get stuck on functions and how to set up appropriate tables.

Here is the type of data I have for selling golf clubs, all set up in one table (UnitTable):

Type Club Qtr Yr UnitsSold

Iron Wedge 1 2006 80

Iron 5-iron 1 2006 20

Wood Driver 1 2006 60

…

I have this data for 12 quarters starting in Q1 of 2005.

I would like the user to do a Find based on Type and then the layout would split back:

Iron: units sold table

Q1 Q2 Q3 Q4 Yr

2007 105 125 120 150 500

2006 100 118 110 130 458

…

Iron: quarter to quarter % change table

Q1 Q2 Q3 Q4

2007 (19.2%) 19.0% (4.0%) 25.0%

2006 18.0% (6.8%) 18.2%

…

Iron: year over year % change table

Q1 Q2 Q3 Q4 Yr

2007 5.0% 5.9% 9.1% 15.4% 9.2%

2006

…

and then the same for Woods

I have zero clue if I should be setting up functions within that one table (to sum up appropriate Club for the Irons, to calculate the Yearly sales, to calculate the quarterly and yearly % change, etc), or if I should make different tables.

And beyond that, I don’t actually understand how to do something simple like sum up all the Clubs that you know are within a Type to get that Type total for a certain quarter.

I am sure there is something out there on the net with a simple example like this, but just couldn’t find it.

I can do simple within-table functions like:

MonthlySalary = YearlySalary/12

But don’t really understand the structure and functions needed for the next level of complexity. Unfortunately I’m not taking another FM class til next month

Any help would be great.

Thank you!