monthly sales history report - given 12 monthly sales by product files
I have 12 files . each file has three attributes a product code , product description and the quantity of units sold for each product .
Would like to merge all 12 months so that a given product code i can see the monthly sales for the last 12 months for each product for a single record .
The problem is some months have products not sold in the previous month hence it is difficult to print out the product description when i use the join outer function . in this case the product description is balnk since on the left set nothing was sold so blank description and product code.
product code product description JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
pc001 peanuts 20 10 0 5 3 3 4 10 5 6 8 10
pc 002 HATS 10 20 40 50