I have a table "A" with several fields. e.g. Toyota, Subaru, Mazda, Sales etc.
Now I need to create Table"B" which will merge some fields from table "A" and SUM up the sales figures in the merged fields. Remember sales are done daily / weekly. Table "B" should have e.g fields Cars, Total Sales etc.
- 2 views