Solved

GetPivotData - Multiple Data Values

Posted on 2013-11-06
1
376 Views
Last Modified: 2013-11-06
With Excel 2003, I've got a pivot table with 3 columns and 11 rows of averaged values.
Image of multiple values in the pivot table.

I'm having a problem calling up these values in a getpivotdata statement.

=GETPIVOTDATA("Totals",$A$12,"AreaName","EASTERN","Average of SINCE_SUBMITTED")
or even
=GETPIVOTDATA("Totals",$A$12,"WellWorkTypeDesc","Abandon - Permanent Plug", "Average of SINCE_SUBMITTED")

GetPivotData.pdf

How do I call up these values individually?
0
Comment
Question by:culpees
1 Comment
 

Accepted Solution

by:
culpees earned 0 total points
Comment Utility
Resolved.

For those who encounter same...

correct formula is =GETPIVOTDATA("Average of SINCE_SUBMITTED",$A$12,"AreaName","EASTERN","WellWorkTypeDesc","Abandon - Permanent Plug"

I had to create a seperate pivot table for the Wellwork Type as it was the 3rd column and for some reason it wasn't getting a grand total or even subtotals. That's a problem for another day.

For calling up data by an area or asset name also though, I had to use the name of the data value instead of the table name itself leading into the GetPivotData funciton.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Scrape Data from a list of hyperlinks 3 28
Calculate days between two dates 7 34
TT Column Arrange 10 26
Macro 3 13
A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now