Results 1 to 2 of 2

Thread: True Many to Many - Product manufacturers and categories

  1. #1

    True Many to Many - Product manufacturers and categories



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have two fact tables: Campaigns and Sales. Normally I use one item table as a look up for the sales facts that is based upon item number which associates manufacturer and product category. The campaign fact table has both of those listings but not an item number which means it is a many to many connection which doesn't work too well. In order to calculate totals, I broke the item table into two pieces: Manufacturer and Product. Some campaigns have a manufacturer but not a product and some have a product and not a manufacturer. I would like to use this data to apply a weighted amount to manufacturers for product campaigns that do not have a manufacturer. I have given these unassigned campaigns generic names in order to build a foundation. What I don't know how to do is to bring the two look ups together. I would like to divide the product spend by the number of manufacturers for that product and assign it to the manufacturer to add to manufacturer specific totals.
    Data in dropbox
    https://www.dropbox.com/s/x9cul41v8c...02.0.xlsx?dl=0

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Thank you Ken for this secure forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •