+ Reply to Thread
Results 1 to 1 of 1

GetPivotData Using Reference in another Sheet

  1. #1
    Registered User
    Join Date
    05-14-2015
    Location
    Kent
    MS-Off Ver
    365
    Posts
    20

    Unhappy GetPivotData Using Reference in another Sheet

    I'm having some issues returning the value into another sheet from a Pivot table using both lookup cells on both sheets.

    My main sheet is called "Event Tracker" and need to get data from "SMIS_Data" which are Pivot Tables using the column "A" in "Event Tracker" the count and date information.

    - if 9220 in column "A4" of "Event Tracker" is listed in "SMIS_Data" sheet under Near Miss pivot table then return value in E4 and so on. The same is for the date but below only returns values in that column and doesn't look between Pivot SMIS_Data!$A$3 and 'Event Tracker'!A4

    Count Events
    =GETPIVOTDATA("Count of lc alcrm ref",SMIS_Data!$A$3,"lc alcrm ref",SMIS_Data!A3,"LC Event Category","Near Miss")

    Latest Date Event
    =GETPIVOTDATA("Max of event date",SMIS_Data!$A$3,"lc alcrm ref",SMIS_Data!A3,"LC Event Category","Near Miss")
    Attached Files Attached Files

+ 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. [SOLVED] GETPIVOTDATA - Can you reference subtotals?
    By Cortney306 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-13-2016, 12:11 PM
  2. GETPIVOTDATA to reference cell
    By ARayburn in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-12-2013, 06:31 AM
  3. Cell Reference of GetPivotData
    By bulldawg15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2007, 05:33 AM
  4. GETPIVOTDATA() with relative reference
    By Sune Fibaek in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2006, 10:50 AM
  5. GETPIVOTDATA using a reference for field name
    By Rayo K in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2006, 05:25 PM
  6. GETPIVOTDATA - return cell reference, not value
    By Slider in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. [SOLVED] GETPIVOTDATA - return cell reference, not value
    By Slider in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-29-2005, 07:05 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