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!