+ Reply to Thread
Results 1 to 3 of 3

Linking a report to a pivot table - Excel 2016

  1. #1
    Registered User
    Join Date
    04-17-2006
    MS-Off Ver
    365
    Posts
    29

    Linking a report to a pivot table - Excel 2016

    I would like to link cells in one table of my workbook to a pivot table on another tab.

    If I click on a certain cell, I get this formula: (History_AWM is the name of the tab with the pivot table.)
    =GETPIVOTDATA("[Measures].[Sum of Net_Flows]",History_AWM!$A$3,"[Range 1].[Year]","[Range 1].[Year].&[2018]","[Range 1].[Quarter]","[Range 1].[Quarter].&[Qtr 2]")

    Instead of the 2018 & Qtr2 values being hard-coded in the formula, is it possible to have then refer to cells in the tab. This would allow me to copy the formula from column to column (or row to row) and use relative references.

    Thanks.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Linking a report to a pivot table - Excel 2016

    I'm going to take a stab at this (untested)

    =GETPIVOTDATA("[Measures].[Sum of Net_Flows]",History_AWM!$A$3,"[Range 1].[Year]","[Range 1].[Year].&[" & Cell 1&"]","[Range 1].[Quarter]","[Range 1].[Quarter].&[" & Cell2 & "]"

    Where Cell1 contains the year and Cell2 contains the quarter.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    04-17-2006
    MS-Off Ver
    365
    Posts
    29

    Re: Linking a report to a pivot table - Excel 2016

    Thank you. This worked perfectly!

+ 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. Replies: 5
    Last Post: 12-04-2017, 10:33 AM
  2. Excel 2016 - Pivot table not refreshing
    By Cubicle Convict in forum Excel General
    Replies: 1
    Last Post: 05-31-2017, 10:11 AM
  3. Can't Sorting pivot table value in excel 2016
    By igoodable in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-18-2017, 03:38 AM
  4. Help: Linking a pivot table report filter to a data validation list in another sheet
    By GlobeTrotter5389 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2016, 11:12 AM
  5. [SOLVED] calculating specific data from a pivot table to create a pivot chart in Excel 2016
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-15-2016, 12:14 PM
  6. Need help linking a combo box to a pivot table report filter.
    By jaimeteele in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2014, 01:56 PM
  7. Linking Pivot table report filter to cell in another sheet
    By onners07 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2014, 02:24 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