AnsweredAssumed Answered

Help with field in a table

Question asked by jd3 on Jan 23, 2011
Latest reply on Jan 25, 2011 by philmodjunk


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!