Closed Thread
Results 1 to 2 of 2

Linking a regular table to a Pivot Table

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Question Linking a regular table to a Pivot Table

    Hello all!!

    I have a question that hopefully somebody can provide the answer to.

    Scenario: See attached image and file. I have an excel file with two sheets: Period Performance Data and Period Performance Pivot. The pivot is based on the data from the PPD sheet. In the pivot table there is a Summary Table. This Summary Table uses the data from the pivot table to formulate an overall performance. See file.

    Goal: I want to make my Summary Table update to reflect the Dept rows from the pivot tables. Ex., If you refreshed the pivot table and Dept C was added as a row then the Summary Table should automatically update to add Dept C. Vic Versa, if the pivot was refreshed and only row Dept A was found in the pivot tables then the Summary Table should only show Dept A.

    Clarification: The data from the data sheet is not really relevant. The Pivot Table works perfectly and when refreshed show the appropriate data. I simply need the Summary Table to update when the Pivot Table is refreshed. How do I do this??

    Any help is beneficial!!! Thank you and let me know if I can clarify anything.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    18,958

    Re: Linking a regular table to a Pivot Table

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ml#post5284416

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Linking a pivot table with another table
    By conquistador in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2016, 04:11 PM
  3. [SOLVED] dax formulas vs. regular calculated formula in pivot table
    By stephme55 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-15-2016, 02:41 PM
  4. Pivot table vs. regular analysis
    By ammartino44 in forum Excel General
    Replies: 2
    Last Post: 09-12-2014, 03:13 PM
  5. linking pivot table to data source table
    By tjgrassi in forum Excel General
    Replies: 2
    Last Post: 07-14-2014, 12:00 PM
  6. Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position
    By webfeet2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 06:34 AM
  7. Macro Help Needed - Link Pivot Table Filter to Regular Table AutoFilter
    By ycx1129 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 12:54 PM

Tags for this Thread

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