Novice here!
I want to compare product sales by sales rep year over year ultimately seeing which products each rep is up/down individual product sales from two years back verses this past year.
Here's the structure of each table:
Tbl_1 - - Rep / SKU / QtyYrBack
Tbl_2 - - Rep / SKU / QtyYrRecent
I don't have a Primary Key for either table.
Here's what I need in one table:
Tbl_YrYr - - Rep / SKU / QtyYrBack / QtyYrRecent
Thanks!