Help with field in a table
I must forecast sales and market share for several products (180) sold in three different regions (East, Central and West). I have created a table with the products, and a table for the regions. I want to be able to keep it as simple as possible yet accurate. In staff meeting, I must show my forecast for each region and then a "roll-up" for total sales.... I get confused how to enter the data in a single table i.e. (forecast table) that will allow me to differentiate each product in separate regions...
Any help will be appreciated!
This is called a summary report and you can get what you need with summary fields to compute your totals and with sub summary parts to group your data by region and compute a sub total for each region.