getpivotdata

Hi all, I am new to the forum and am hoping that I could get some help! I am trying to pull data out of a pivot table, and below is my formula. =GETPIVOTDATA("[Measures].[Occ]",'BI-Occ'!$A$5,"[Market].[Market Code]","[Market].[Market...

I'm trying to get a 52 week sales/inventory report to auto fill from a data dump in the form of a pivot table. The only problem is that if there is no sales data from a week then that week does not show up in my pivot table because of the lack of source data. For example if there were no sales...

Can slicer selections be used as criteria for getpivotdata formulas? I am trying to present a report that looks cleaner than a filtered pivot table typically does. Any suggestions? Thanks!

Hello, I have several columns populated with GETPIVOTDATA formulas. Each formula refers to a different item, but they are all organized by months. Now I need to have the exactly same formulas applied to the next column, but showing the next month, e.g. instead part of my formula to be...

Hi, I have really been struggling with this and have no Idea what to do. Here is my formula: =IF(ISERROR(GETPIVOTDATA("Flavour Trend",UNFIFlavourTrend!$B$3,"Date","Mar")),0,GETPIVOTDATA("Flavour Trend",UNFIFlavourTrend!$B$3,"Date","Mar")) When I get new information I paste it in the sheet...

Hi everybody I'm new to the forum and kind of newbie with excel, and just for your information I have no knowledge of macro or VBA. I am trying to prepare a reporting for weekly sales, and I use many pivot tables in my calculations. Until now I have build formulas using getpivotdata function...

Hello, I'm building a simple excel dashboard, which I'm basing off of a large pivot table and the output is using Get Pivot command and the user parameters are passed into the get pivot command. Here is simple example: =GETPIVOTDATA("Sales $",$A$3,"Branded","NO") So the user would pick YES or...

Hi this is my first post so if I'm doing this wrong I apologize. I have an issue with pivot tables (I'm not very good yet). I have an oracle database connection with the excel and as it pulls the data in, I have the pivot table breaking it down into each week. I need to be able to pull specific...

Hi Guys, A beginner at using macros / advanced stuff in excel. I need help with cleaning up a spreadsheet for work. Issue. I need to get data from a pivot table into a new tab. The data from the pivot table is pasted into one tab and then the pivot table is refreshed in another. Once the...

I am looking up data using GETPIVOTDATA, using a number of parameters including country, product name and date. The GETPIVOTDATA formula automatically looks up the appropriate country, product name but when I try to automate the DATE there is a #REF! error. The GETPIVOTDATA formula uses...

Hi, I am having problems with my report generation, earlier we were using multiple pivots to build a single report, which was time consuming. I have sorted out most of the problems by building a single pivot and using getpivotdata. But one of the few problems I have now is with getting the...

Hi All, I am having trouble with a formula to calculate the average of a GetPivotData range (4 different values) while excluding values of 0. I can get the formula to work using the following Average formula, =AVERAGE (GETPIVOTDATA("Average_Estimated_Pax",'Data Pivot (Avg LG...

I have a spreadsheet and I am trying to pull the quantity purchased in the current month, plus any open back-orders we may have for that item. Is there a way to have the GETPIVOTDATA function to pull data from any date before a specified date?

Hi All, I have a pivot table from wich I am trying to get Customs Subtotals using the GetPivotData function. This is the calls from an Excel Formula, which works well. =GETPIVOTDATA($C$4,"ModelId['100233';Sum] EQ_EUROPE") $C$4 = is the top left cell of the PivotTable How can I get this to...

Hello, Would anyone know what to get the Grand Total of a Pivot Table to export out to another sheet when the table refreshes. Because the Pivot Table refreshes the location of Grand Totals keeps changing, breaking my formula. I have been told GetPivotData function would work for this but I...

Hi guys, </SPAN> I have the following problem. </SPAN> I have a main table with 6 fixed headers. From which I would like to fill the first 4 headers (columns) with data from a pivot table. The pivot table which will be used as the source also has fixed headers/columns, however the number of...

Hi I have a spreadsheet that contains property costs and have created a pivot table for this data. I also have hundreds of seperate workbooks for individual properties that feed off the costs pivot table by way of an =GETPIVOTDATA formula. The issue I am having is that when I update the cost...

Can anyone tell me how if it is possible to create multiple =getpivotdata formulas at a time. I am extracting data from a pivot table to other cells (and then hiding the pivot table). Consider the below pivot table: ___J. Harb N. Bull S. Lee US 100 50 77 CA 50 10 40 MX 80 40 40 CO 45 40 40...

Hello, thanks for any assistance. I'm have a pivot table on one worksheet, which pulls from the same workbook. However, I am attempting to pull additional detail broken down by location on a separate worksheet (to show detail by location). I have tried to use the getpivotdata formula, but...

Hi All, I am using the same formula to get data from one pivot table: =GETPIVOTDATA("Sum of No. Reqd",'OCC90 PivT Level 3 Forms'!$A$3,"Sub-System",B234,"Disp.","OVERALL","Week #","") this is the formula that excel automatically wrote when I clicked on the cell I wanted to read data from in...