+ Reply to Thread
Results 1 to 2 of 2

Pivot Table containing data from 2 sheets

  1. #1
    Registered User
    Join Date
    05-31-2021
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2019
    Posts
    1

    Question Pivot Table containing data from 2 sheets

    Guys I need some help with this. It requires the Rows to contain the name of the subscriber but the data is from the other sheet and can't get it done. Which data should I make relationship in order to get it done?

    Excel test:
    You have excel file containing two sheets:

     Customers: the name and the phone number of each
    subscriberWhi
     Traffic: Calls, revenue and duration(min.) per phone number,
    month, destination and tariff plan

    Create pivot table containing the traffic duration of each
    subscriber per month with the following parameters:

    a. Rows: Name of subscriber
    b. Columns: Months

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Pivot Table containing data from 2 sheets

    Hello armanski15 and Welcome to Excel Forum.
    The description sounds like something that might be accomplished using Power Pivot, where a one to many relationship between the phone number on the Customer sheet and the phone numbers on the Traffic sheet could be established.
    It may help us to better understand if you would upload an Excel file showing the data on the two sheets (instructions are given in the banner at the top of the page).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table problem - how to relate 3 sheets' data into 1 pivot table?
    By GRG Stevan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2015, 06:12 AM
  2. Pivot table for Multiple data sheets
    By elqueso in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-03-2015, 10:00 PM
  3. [SOLVED] Generating Separate Sheets from Pivot Table Data
    By Suzerain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2014, 08:03 PM
  4. how to get data from several sheets on to pivot table
    By dougers1 in forum Excel General
    Replies: 15
    Last Post: 09-09-2014, 01:11 PM
  5. using two data sheets in Pivot table
    By vivekdevkar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2010, 07:06 AM
  6. Refreshing pivot table data when moving between sheets
    By sayed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2010, 09:50 AM
  7. Two Data Sheets to make One Pivot Table
    By Sarina2424 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2010, 06:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1