getpivotdata

I have a large pivot table and I want to identify the beginning of a sum array by using GetPivotData, then down a variable number of cells. Is this possible?

Hey guys! The forum has been great so far - thanks for everything you do. So I've generated a PivotTable and need to retrieve the grand total associated with the last row item in the PivotTable using VBA. What I have currently gets me month-specific data, but once we add more months, the code...

Hi Everyone, I have created a pivot table from two different tables using power query. Now i am looking for a look up formula which can get the data from the pivot table. Please find attached the picture of my Pivot Table for your reference. The formula looks like this...

Is there a quick way to turn an automatically created GETPIVOTDATA function into a cell reference formula? For instance, this: =GETPIVOTDATA("Net Amount",'[FileName.xls]Month'!$A$3,"Unit","02","Group","A") returns the same thing as ='[FileName.xls]Jul'!$C$10 I want to use the get...

I realize there are a ton of existing posts about GetPivotData and apologies if this question has already been answered previously but I wasn't able to find it. I'm not sure what the best way to describe it is so that may be part of the problem. I can't get GetPivotData to work when I have more...

Hi, I am trying turn a rota into an automatic rota where it fills itself when data is dumped into another worksheet and updated via pivot tables. Thier shifts are already pre-set from another worksheet with shift codes linking to the rota tab via vlookup. The outcomes on the rota are; in, late...

I have a pivot table with a lot of data in it. I am summarizing that data using the GetPivotData command. The data contains engagements (thousands of them) and then subtotals for hundreds of different activities. All of the sub-total hours across all activities is the "Grand Total" for each...

https://drive.google.com/file/d/0B9uhATNT4QB2dDYxVDhiZGtFdG8/view?usp=sharing https://drive.google.com/file/d/0B9uhATNT4QB2SlhnQlBIcmhMVlU/view?usp=sharing https://drive.google.com/file/d/0B9uhATNT4QB2MkEzY0RMaU04dGc/view?usp=sharing EXCEL File -...

I am totally frustrated by the fact that I have been using [=GETPIVOTDATA("Sum of Clicks",LinkedIn!$N$2,"Year",2016,"Month",September)] every month since January's data and it has been working but this month 'September' it cannot fetch the data from the Pivot Table even though the data is in...

I have two perfectly functional formulas that pull data from a pivot table. I want a formula that actually just adds those two numbers together The working formulas I have are: =GETPIVOTDATA("total_imps",C87,"site_rollup","cbs","platform_type","Desktop","ad_grouping","Native Slot - Native...

Hi, I am wanting to use getpivotdata to take the value from a pivot table for use in my main worksheet. I have managed to get that to work. What I am struggling with is I was to be able to use a value in cell (C5) for the year YY ie 16 on the sheet that formula is on. I have tried to...

This should be simple, but I've fought it for DAYS. HELP! Excel 2010. PowerPivot with 3 tables. A few PowerPivot pivot's are in my Excel sheet. On a regular sheet, in a regular cell, in A1 I want to enter a customer ID. In A2, I want to display the customer's name. I can get measures &...

Hi I have some sales data, I use Pivot Tables to organize the data into countries. So I have a column of countries with a column of sales for each country. Now I would like to sum up the sales into various groups, namely: 1. Germany 2. Europe 3. Non Europe I can do this manually by using...

Hi, I am trying to use the GETPIVOTDATA formula to fill in the table below: <tbody> Date 12/7/2015 12/8/2015 12/9/2015 12/10/2015 12/11/2015 Sales </tbody> My pivot table looks like such: <tbody> Date Sales 12/7/2015 300 12/8/2015 120 12/9/2015 150 12/10/2015...

I have a company that has a list of accounts. I need to see how many lines were canceled and kept for each account as well as for the company as a whole. So for example, for Account 4, it canceled 33% and kept 67% and Company 1 canceled 8% and kept 92%==>8% = sum(0,0,0,.3333,.5,0,0,0,0,0,0)/11...

I am new to the site and hope to gain some assistance with a problem I have been working on. I have a pivot table with multiple row labels: Column B: SNR Manager Column C: Manager Column D: Supervisor Column E: Employee Other columns contain pivoted data points What I am trying to do is create...

I'm trying to create a formula in sheet 1 (below), that checks the column heading and the row heading, and then returns the data in the corresponding row and column heading from sheet 2 (which is a pivot table, and hence the data changes rows/columns each time it updates). I don't seem to have...

I'm currently pulling information from a pivot table using the following formula =GETPIVOTDATA("Account",'Debt Free'!$C$3,"Centre name","Charlestown","closedmonth","1","closedyear","2015") However I wish to change this to the following where the location is based upon two other cells...

I am entering a GETPIVOTDATA formula in a table that I would like to refer to the value in another table column The following formula works for SKU 100007 =GETPIVOTDATA("[Measures].[DAILY DEMAND NEXT 8 WEEKS]",'PLANNED ORDERS'!$B$3,"[PlannedOrders].[SKU]","[PlannedOrders].[SKU].&[100007]")...

Hello All, I am trying to pull data from a pivot table, but I want one of the criteria in the formula to change based upon another column in the same row as the formula. What I have so far is this. =GETPIVOTDATA("AMOUNT",PriorActualLookup!$A$4,"Project Exp Month","January","PROJ #","7356")...