Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Create pivot table from 2 sets of data to produce pricelists

  1. #1
    New Member
    Join Date
    Aug 2012
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Create pivot table from 2 sets of data to produce pricelists


    Create pivot table from 2 sets of data to produce pricelists
    Hi there,

    Is it possible to create one pivot table from 2 different sets of data?
    I have some 1,500 customers (each on different pricing levels) and around 90 products. Ultimately I would like to be able to generate pricelists for each customer group (or by distributor) using the 'show report filter pages....' option under pivot table options.

    Hope that makes some kind of sense! I can send a dummy file that may help explain better (cant find how to attach it!!!)

    Hopefully there's a guru out there that can help! Many thanks.

  2. #2
    Board Regular
    Join Date
    May 2010
    Location
    St Albans, Herts
    Posts
    398
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create pivot table from 2 sets of data to produce pricelists

    Should be pretty easy as long as there is one field that can used to create a realtionship between the customers and the products.

    Sent me a dummy file by email and I'll have a look

    Mike

  3. #3
    New Member
    Join Date
    Aug 2012
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create pivot table from 2 sets of data to produce pricelists

    Hi Mike,

    Just sent you the dummy file.... thank you so much for assisting.

  4. #4
    Board Regular
    Join Date
    Aug 2012
    Location
    Charlotte, NC
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create pivot table from 2 sets of data to produce pricelists

    Hi ninti777

    Is the structure of your two sets the same? I recently wrong a small blog entry on how to merge two different sets of data in a scenario similar to yours

    Merging data in PowerPivot « Javier Guillén

    Javier

  5. #5
    Board Regular
    Join Date
    May 2010
    Location
    St Albans, Herts
    Posts
    398
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create pivot table from 2 sets of data to produce pricelists

    Hi Sue. sorry delay been head down on my end of month. Just looking at the dummy file I'm not quite sure what it represents. Few questions:

    1. Do you want to set differrent prices for Product A,B,C etc depending on the customer?
    2. Is a pricing level used by several customers or prices set indiviually for each customer e.g. price Band A = $10 for XX1, $20 for XX2 and 15 customers are on this price?
    3. Is Data Table A the output you have to work with or could you change the format?
    4. Does each customer only have 1 distributor?
    5. What is the relevance of the start and end date? Mike

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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