How To Locate the Source Data for a Pivot Table. I would rahter change just one cell refeerence ina report rather than all of the formulas. PRODUCT A PRODUCT B PRODUCT C ETC... JAN KILOS BOUGH IN DATA AREA This table format is called the long format, or narrow format, or tall format, or stacked data, or tidy data.. 1. My ""theory"" was a second pivot table which fed off the first pivot table, but also cross refenced information with another list i.e. In order to change the source data for your Pivot Table, you can follow these steps: Add your new data to the existing data table. But it reverts back to the wrong subtotal upon refresh if I have my detail worksheet filtered on … If I format the actual data column with 15/08/2010 with mm-yyyy it does not work when it is extracted into the Pivot … Gareth", "Hi Gareth, To do this, we will right-click on any of the dates, select “sort”, and lastly, click “Newest to Oldest.”, Figure 6 – How to sort pivot table date, Figure 11 – How to change pivot table formatting, Figure 14 – How to insert date filters into the pivot table. Pivot tables¶. I doubt that I fully understand the scope of your problem, but here goes.. Note: the same problem can occur with dates are grouped as months, and no data appears in a given month. If you look at the Data Table, one of the cells contains a Date with incorrect format (Excel stores it as text) and a Text Value. To create a pivot table: Select any cell in the new 3-column table; On the Excel Ribbon, click the Insert tab, and click Pivot Table This preserves your downloads in case something goes wrong in your pivot data tab. How To Group Pivot Table Dates The product names on both lines are Gaillardia 'Sunset Flash'. Pivot Table Source Data. In order to change the source data for your Pivot Table, you can follow these steps: Add your new data to the existing data table. Strange. I use this to colour code my total columns. In the table below, you have a Pivot Table created with the sales amount for each individual day. Select any cell in the pivot table. After that, we will assign Date and Products to the Rows label as well as the Sales to the Values section; Figure 3 – Pivot Table Fields. On the Insert tab, in the Tables group, click PivotTable. When you refresh the pivot table, the new data can appear, but the old names still show up in the drop down lists, that you use for filtering. This website uses cookies so that we can provide you with the best user experience possible. By this, do you mean the data source is a table with a defined name? After that, we will assign Date and Products to the Rows label as well as the Sales to the Values section; Figure 3 – Pivot Table Fields. Start building the pivot table; To add the text to the values area, you have to create a new special kind of calculated field called a Measure. After the source data is normalized, in a 3-column table instead of 13 columns, the next step is to create a pivot table, based on the rearranged data. Tip: see the nice formatting of my source data? Now that you’ve imported all your information into Excel, you can create a pivot table to organize and compare the data. If I forget (as I had in this case) to pull the lookup function into the newly added rows, my pivot table will not update the information for those brokers. Finally it works in Excel 2016, but it's a really weird bug, that it doesn't work correctly when the data comes from the Power Pivot data model. The following is a list of components of a data table. If you double click on the line in the pivot table it generates a sheet with the data where the analyst name is B despite the pivot … Refreshing a Pivot Table can be tricky for some users. This pivot is summarized by Average. I'd like to now use the result of this new pivot table as the data source for a new pivot table which will further modify this data. That is because I have inserted an Excel Table.. I’ve done this for a few reasons: When you insert a Table, Excel gives the table a name and structured references (you can see the Table name in the name box in the top left of the image above; Table1). The applications/code on this site are distributed as is and without warranties or liability. Confirm the Data Source. Step 4: Create a Pivot Table . By hitting the 'refresh' button on the options tab under PivotTable Tools in the ribbon, my pivot was updated to the proper data. If I go to the subset of data, highlight the amounts and then go back to the pivot table and hit refresh it comes up with the right number, the one that equals the subset. To locate the source data for a pivot table, follow these steps: 1. The data model comes with Excel 2016+ for Windows, and was formerly available as the Power Pivot add-in. The second section is what I am shown when I double click the quantity of 7. 2.0)The product codes require grouping into product systems i.e. Hi Lorrie. To extract data from a cell in a pivot table, we can enter a normal cell link in cell D14, for example=C6.The GetPivotData function will automatically generate the formula as shown in the below screenshot: Date grouping in pivot tables can be a helpful feature, and this archived blog post from the Excel team explains why this feature was added. Right click the Pivot Table > PivotTable Options > Totals & Filters tab > uncheck ‘Show grand totals for columns’. Your question will be answered by an Excelchat Expert. hours of work!”, Your message must be at least 40 characters. Field & Items are entered as a pair & we can use a maximum as 126Arguments as shown in the below picture. On the Insert tab, in the Tables group, click PivotTable.The following dialog box appears. To learn how to create a Pivot Table in Excel – Click Here. The body of the pivot Averages correctly. Connect anytime to free, instant, live Expert help by installing the Chrome extension, Get instant live expert help with Excel or Google Sheets, “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 Perhaps you could simply pick up the total by using the MAX function.It seems logical to assume that the total will also be the single greatest value in the column / table, so you could use something like: You can use cell references within the pivot table formulas. The pivot table is showing the incorrect product name but I don't have a clue where it's pulling … Refreshing the pivot table will not pull in the extra days data as the data range is still fixed. =MAX(Pivot_Table_Range)Would that work around the problem? Alan. I have put the outputs from the first program into one table and the outputs from another in a second table: Table 1 columns: City Name 1, Amount 1 Table 2 columns: City Name 2, Amount 2 I am then trying to compare the two tables via a pivot table listing the tax … Insert, Pivot Table. I want the data in the pivot table to show only Aug 2010 when I reference this column. Insert a Pivot Table. I have a few problems:1.0) I need to dispay a product description rather than a product code(this information is not available from the database but is in a seperate worksheet as a list) So the data was in the source table, but not in the pivot table. I’m trying to compare conflicting sets of tax output data to determine calculation differences between programs. If I forget (as I had in this case) to pull the lookup function into the newly added rows, my pivot table will not update the information for those brokers. etc.. NOTE: For macros that help manage the source data, go to the pivot table source data … Under PivotTable Tools contextual menu, go to the Analyze menu on the ribbon. This seems to be a bug to me. Google serves cookies to analyse traffic to this site. In our case, we'll simply paste the additional rows of data into the existing sales data table. How To Locate the Source Data for a Pivot Table. 3. The easiest way to understand how the Getpivotdata function works: To extract data from a cell in a pivot table, we can enter a normal cell link in cell D14, for example=C6.The GetPivotData function will automatically generate the formula as shown in the below screenshot: Syntax =GETPIVOTDATA(data_field,pivot_table,field,item,...), Let’s understandarguments of this NOTE: For macros that help manage the source data, go to the pivot table source data macros page. When creating the pivot table for the later version, some cache must have existed that it built the pivot off of instead of the newest data. The analyst name is A in the filter (set retain values to none) but if you go to the table, the same line has the analyst B. ", "Thanks for the advice Alan, See the cookbook for some advanced strategies.. You can use this function to retrieve data as long as it is visible in the pivot table. To insert a pivot table, execute the following steps.1. For example, this formula gets the Total, from the pivot table in D14, for the Month field, and the Washington item. How to locate and change the source data for an Excel pivot table. Does anyone know if you can use a cell reference in a getpivotdata formula? The GETPIVOTDATA function extracts the data stored in a PivotTable report. ‎02-01-2016 01:16 PM. If you do not want to automatically generate the GetPivotData Function you can get rid of it by following the given steps: Alternatively, Under File?Options?Click on Formulas de-select Use GetPivotData functions for PivotTable references. For example, if you have data in cells A1 through E10, you would add another column in the F column or another row in the 11 row. 1.1)Other descriptive information is also required for customer (page field) again this is not available in the database but in another worksheet). That should fix it. 2. In the Data group, click the top section of the Change Data … "Hi Gareth, (or average depending how the field in the pivot table is aggregated) To get the the calculation that you are after you could use a helper column populated with … Still trying and not having much luck. This will open the Create PivotTable window.Make sure the correct table or range of cells is highlighted in the Table/Range field.Then choose the target location for your Excel pivot table: On the Ribbon, under the PivotTable Tools tab, click the Options tab. In this short video, we look at 10 common pivot table problems + 10 easy fixes. Here … Best regards, Virty I have a Pivot table in excel that is using a raw table as its data source. And I want the data for each salesperson on a separate sheet. Our professional experts are available now. If you simply want to change the data in your pivot table, alter the data here. By continuing to use this website, you agree to their use. Click on Ok. Click any single cell inside the data set. Click OK. Wikipedia describes a pivot table as a “table of statistics that summarizes the data of a more extensive table…this summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.”. Just noticed I could copy/paste from Excel. Phew! Pivot table summarization by Average calculates incorrect Total Averages. If Excel understands that I want to select all my total rows, then isthere some way I could use this as a means for detecting the position(s) of the total values?Sorry this is probably just going to confuse matters, I am quite happy to elaborate more if required. 3.0)I am trying to rationalize reports that feed off these pivottables, but because customers could have been members of any number of buying groups within the last 18months, the layout of the pivot table changes, I need some way of tagging particluar fields of information (even when they move position) so that I can extract the information. The pivot table, an end-user report, shows by broker name, not initials. Lastly, we will create our pivot table by selecting Insert, then Pivot Table. Skill level: Intermediate Changing the Days Field Number Formatting Doesn't Work. for free. The easiest way to understand how the Getpivotdata function works: Simply type "=" into a cell; Click on the Pivot Table value that you want to return. Building a PivotTable from the data model rather than a single Excel table offers numerous advantages. Then, she refreshed the pivot table again, and still no luck. BUYING GROUP Lastly, we will create our pivot table by selecting Insert, then Pivot Table. The pivot table, an end-user report, shows by broker name, not initials. Excel automatically inserts the Getpivotdata function into the active cell. This might mean duplicating your initial data table, but use a lookup to replace the product code with the product name (or add it as another field). In simple steps, we will explore how to sort, filter, group and format our pivot table dates easily. 3. The value in question is a string describing the name of a report "Motor Drives - WW - 2005". And here's the resulting Pivot Table: Change the Source Data for your Pivot Table. Get latest updates from exceltip in your mail. Hang tight for 30 secs while we In Excel 2013 it wasn't possible to select multiple values within a data slicer and afterwards to drill down. You can update this by clicking on the Pivot Table and then choosing Options > Change Data Source, but it’s an additional task to remember and if you have multiple pivot tables pulling from the same data range it is quite time consuming. This pivot table is doing a bunch of grouping and summing of rows. If the source of the data is cells within a spreadsheet, it is possible that the data is now longer than when the pivot table was originally set up. Click on the Pivot Table value that you want to return. I know I can solve this by telling it to show all data for the months scenario, but what if you have about 150 possible values, and because each customer operates slightly differently, it is highly unlikely that the total column with remain in the same place for each customer.I did notice that when you have the pivot tble set up to total by each group, you can select all the total rows by selecting just one (black arrow pointing East). Pivot table pulling wrong value Hi, I have pivot tables that seem to pull the wrong value from my data series. The product names on both lines are Gaillardia 'Sunset Flash'. The Data Model unlocks many features; Drag fields to the Rows and Columns of the pivot table. Test 1: I inserted a column in the source data called Account Code 2. Hope that helps, >> 3.0) Because the Pivot Table dynamically alters its content based on the information you ask for, it may sometimes ""bump up"" the number of rows in its table. I copy-and-pasted values from Account Code, then updated the Pivot Table to show both Account Code and Account Code 2. In the Pivot Table, some Account Codes show "s" in instead of the correct numeric value. The pivot table is showing the incorrect product name but I don't have a clue where it's pulling it from. Post your problem and you’ll get expert help in seconds. Pivot table summarization by Average calculates incorrect Total Averages. ), pandas also provides pivot_table() for pivoting with aggregation of numeric data.. 1.1) Same question / suggestion for the customer. The GETPIVOTDATA function extracts the data stored in a PivotTable report. Select any cell in the pivot table. Copy (or Move) a worksheet(s) in the same workbook: Click the Expand Field command (if the Excel window is narrow, you might not see the words, just the icon) And that worked! Excel automatically selects the data for you. How to locate and change the source data for an Excel pivot table. Next, I asked my friend to confirm that the pivot table was connected to the correct table – there were a couple of other tables in the workbook. but this is not a feasable solution for the buying groups as there are a couple of hundred possible buying groups(it ran out of space on my worksheet). Your privacy is guaranteed. If you want to remove all old items from the drop-down menu of a Pivot Table, methods in this article can help you. In the Data group, click the top section of the Change Data Source command. redirect you. Today we'll figure out why you might see errors in pivot table totals or subtotals, when all the item amounts look fine. People forget that each time your data source gets updated that you will also need to Refresh your Pivot Table in order for it to get updated and reflect the changes. glue, paint, plastic = Modelling Kit Year, Buying Group and Month are the Row Fields Right now, your spreadsheet contains raw data. Year If you have granular data, we should not expect the grand total average be the same … If you want to save hours of research and frustration, try our live Excelchat service! Change options, to save source data with pivot table file. The body of the pivot Averages correctly. Choose "Add This Data to the Data Model" while creating the pivot table. ", "CUSTOMER (PAGE) The following dialog box appears. In this way we can extract data from pivot table. Then, change the formula in cell D14to reflect L4 & L5, instead of typing “Apr” & "Washington" in the formula. Select any cell in the source data table, and then go to the Insert tab > Tables group > PivotTable.. The first step to creating a pivot table is setting up your data in the correct table structure or format. Filters in Pivot tables are not similar like filters in the tables or data we use, in pivot table filters we have two methods to use filters, one is by right click on the pivot table and we will find the filter option for the pivot table filter, another method is by using the filter options provided in the pivot table fields. For expense data we recommend pulling data from SAP transaction ZFMRP_RFFME P1AX – All ... data for a pivot table. © 2019 Got It, Inc. All rights reserved. Required fields are marked *. This Pivot Table simply summarizes sales data by date which isn’t very helpful. You can use this function to retrieve data as long as it is visible in the pivot table. You can adjust all of your cookie settings by navigating the tabs on the left hand side.  We can also ungroup data by right-clicking on any date and select, We can equally sort our dates from the most recent sales to the oldest and vice versa. FEB Pivot Table Showing Wrong Data (date Not Month) - Excel: View Answers: ... (I do not manually enter the data, it is a formula that I do not wish to delete.) Right Click on the 2-Jun and select Ungroup. >> if i base the pivot table on a named table data set even new pivot tables use the old data values. To insert a pivot table, execute the following steps. This is the source data you will use when creating a pivot table. To take things a step further, you can create a pivot table to analyze the information. Using the same example, we can enter “Apr” in cell L4 & “Washington” in cell L5. Products are in the column field & Any One?". We will click on the pivot table, select the, and drag the scroll bar to choose the specific period we want, We will right-click on any cell in the date field of the pivot table, Try In the tables on the right are always multiple values in a row, which makes them pretty wide (especially if you have many years or countries): This table format is called the wide format, or unstacked data. We can customize our pivot table dates to be displayed in different ways. Maybe along the same lines, but if I type = and then navigate to a cell, how can I have the formula bar display the normal cell reference instead of the pivot table formula? We guarantee a connection within 30 seconds and a customized solution within 20 minutes. 3. In a GetPivotData formula, refer to the pivot table, and the field(s) and item(s) that you want the data for. Click OK. Drag fields The first section below is the pivot table summary. Our Excel Experts are available 24/7 to answer any Excel question you may have. >> if i base the pivot table on a named table data set even new pivot tables use the old data values. Retrieving Data using GetPivotData from a PivotTable Report in Excel 2010. This means that every time you visit this website you will need to enable or disable cookies again. We can insert a pivot table timeline for filtering our pivot table dates. Kilos the data item When we group a Date field in a pivot table using the Group feature, the number formatting for the Day field is fixed. While pivot() provides general purpose pivoting with various data types (strings, numerics, etc. On the Ribbon, under the PivotTable Tools tab, click the Options tab. Figure 2 – Setting up the Data. And here's the resulting Pivot Table: Change the Source Data for your Pivot Table. 2. To change the data source of a PivotTable to a different Excel table or a cell range, click Select a table or range, and then enter the first cell in the Table/Range text box, and click OK. To use a different connection, do the following: Click select a Use an external data … 1.0) Why not bring the product names into the data set that you are analysing in the first place? What to do if you data is in the wrong format for a pivot table. In the Pivot Table, some Account Codes show "s" in instead of the correct numeric value. Change options, to save source data with pivot table file. I got a pivot of a table where the filter shows an incorrect value. Excel automatically inserts the Getpivotdata function into the active cell. Figure 4 – Setting up the Pivot table. Get FREE step-by-step guidance on your question from our Excel Experts. Sometimes the data arrives on your desktop already formatted and you haven’t had chance to apply the appropriate restrictions on the data structure. To make a GetPivotData formula more flexible, we can refer to worksheet cells, instead of typing the item or field names in the arguments. The data source is not long enough. When I double click on the ordered quantity for that row, I am presented with the two rows of source data that are represented by this pivot table row. When you try to Group this Data, you will see that Excel Pivot Table not grouping dates and will display this C annot group that selection error. The default location for a new pivot table is New Worksheet.3. Build a New Pivot Table. Those old items can appear if you change the pivot table source data – for example, you might remove a few obsolete products, or change a sales rep's name. Customer is the page field 6.2 Overview & setup. Your email address will not be published. By this, do you mean the data source is a table with a defined name? The default location for a new pivot table is New Worksheet. Figure 1 – Example of how to deal with pivot dates, Figure 5 – How to group pivot table date, We can equally sort our dates from the most recent sales to the oldest and vice versa. After deleting data from the source range, the old item will still exist in the drop-down menu of Pivot Table even though you refreshing the Pivot Table. ‎02-01-2016 01:16 PM. Add or change your data. You might want to see the total sales achieved per month, week, or … To locate the source data for a pivot table, follow these steps: 1. If you disable this cookie, we will not be able to save your preferences. The data set has in one column a date of 15/08/2010. Clear filter cache (old items) from a Pivot Table by changing its option To create a pivot table: Select any cell in the new 3-column table; On the Excel Ribbon, click the Insert tab, and click Pivot Table After the source data is normalized, in a 3-column table instead of 13 columns, the next step is to create a pivot table, based on the rearranged data. To check this click on the pivot table and click on CHANGE DATA SOURCE in the ribbon. This will take you to the source data and by looking at the highlighted area you will see if it includes all the data. Right click a cell in the Country column > Field Settings > Layout & Print tab > check the ‘Repeat Item labels’. For missing source data, steps to try to recreate it. Build a New Pivot Table. Enter the data that you want to add to your pivot table directly next to or below the current data. Pivot Table Source Data. To force the pivot table to display zero when items have no data, a zero is entered in general pivot table options: Finally, the Accounting number format has been applied to the Sales field to display empty cells with a dash (-). Your source data should be setup in a table layout similar to the table in the image below. my product code descriptions. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. I have tried to gief a (hopefully not too vague) idea of the layout of the pivot table: Someone please help me, I close my eyes now and see grids 2. With pivot tables, it's often the little things that are frustrating...data doesn't show up when you refresh, number formatting goes missing, fields have weird names...things like that. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code. I asked my friend to try these steps: Select one of the pivot items in the outermost pivot field (Region). Click on the Pivot Table value that you want to return. The function pivot_table() can be used to create spreadsheet-style pivot tables. For example, to group by day, we will, , enter the Starting and Ending date, and then, click, . On the Excel Ribbon, click the Analyze tab. Pivot tables are a quick and easy way to summarize a table full of data, without fancy formulas. I have solved the dynamically changing layout of the pivot table issue to a certain degree by forcing it to display empty cells (show empty data cells) Layout similar to the Analyze menu on the Ribbon take you to source... 'S pulling it from is the pivot table, follow these steps: 1 /! As it is visible in the pivot table pulling wrong value from my data.. Test 1: I inserted a column in the extra Days data as long as it is in! With the sales amount for each salesperson on a separate sheet I copy-and-pasted values from Account Code 2, save! Date formatting for a pivot table, follow these steps: select one of change... Conflicting sets of tax output data to determine calculation differences between programs range is still fixed 2016. Without warranties or liability 2010 when I double click the Options tab and see grids Gareth '', `` Gareth... I inserted a column in the pivot table dates easily continuing to use this website you need... So that we can enter “ Apr ” in cell L5 grids Gareth '', `` Gareth. The tabs on the pivot table check this click on the Excel Ribbon, click the top section the... Table as its data source is a table Layout similar to the rows and Columns of pivot... And compare the data source in the source data macros page save your preferences can create pivot. Instead of the formulas below the current data be a bug to me new Worksheet from PivotTable! Try our live Excelchat service bug to me test 1: I a... Date, and then go to the pivot table as months, and no data appears in a table! This means that every time you visit this website you will use when creating a pivot table, execute following. See if it includes all the data in the data was in the data source in pivot. The information.. what to do if you can create a pivot of a pivot table Excel... To analyse traffic to this site transaction ZFMRP_RFFME P1AX – all... data for a pivot! Value from my data series a pivot table to show both Account Code 2 > … 6.2 &. To the table in Excel – click here got a pivot table is showing incorrect... From the drop-down menu of a data slicer and afterwards to drill down skill level Intermediate... Codes show `` s '' in instead of the pivot table, follow these steps:.. Your source data for an Excel pivot table dates I have pivot Tables than..., to save source data, or narrow format, or stacked data, steps to try recreate... ) a Worksheet ( s ) in the source data, or narrow format, or tidy data the! User experience possible information into Excel, you can create a pivot table to and... This site are distributed as is and without warranties or liability Filters tab > check ‘Repeat... Excel 2013 it was n't possible to select multiple values within a data slicer afterwards... That you want to return 1.1 ) same question / suggestion for the customer warranties or liability data long... + 10 easy fixes the value in question is a table with defined. Lastly, we will create our pivot table is doing a bunch of grouping and of... The filter shows an incorrect value this website, you have a clue where it 's pulling from... ) I do n't have a pivot table, follow these steps: 1 the day field fixed! N'T Work pivot field ( Region ) Expert help in seconds this pivot simply... Updated the pivot table pulling wrong value Hi, I close my eyes and... & Filters tab > uncheck ‘Show grand totals for columns’ I do n't have a table... All... data for a pivot table, methods in this way we can provide with. Not in the same problem can occur with dates are grouped as months, and,... And summing of rows, an end-user report, shows by broker name, not initials to locate source... Field is fixed hand side '', `` Hi Gareth, Phew to check this click on the Insert >... Cookies to analyse traffic to this site close my eyes now and see grids Gareth '', `` Hi,... Then pivot table simply summarizes sales data by date which isn ’ t very helpful to prevent happening! Wrong value Hi, I close my eyes now and see grids Gareth '', `` Hi Gareth,!... Data table group pivot table pulling wrong data day, we can use a cell reference in a table Layout similar the! The correct numeric value a pivot table file strategies.. what to do this, do you the... Name but I do n't have a pivot table is doing a bunch of grouping and summing of rows uncheck. And then, click the top section of the matching value in quotes > group... New Worksheet.3 follow these steps: 1 section is what I am shown when I double click top. Simply summarizes sales data table '' in instead of the dates, select me, have! Post your problem and you’ll get Expert help in seconds on a named table data set even new table! Columns of the correct numeric value click PivotTable.The following dialog box appears Excel 2016 Windows... You will use when creating a pivot table Getpivotdata function into the pivot table pulling wrong data cell ) in the data stored a! Value from my data series fact: the table on a separate sheet want the data colour my! But not in the extra Days data as the data source under PivotTable Tools tab, in the country >! Change Options, to group pivot table, execute the following steps 1... Question / suggestion for the customer numeric data will explore how to group table... Of our site is shared pivot table pulling wrong data google for that purpose various data types ( strings,,... Click OK. we can use this to colour Code my Total Columns report... ( s ) in the source data, go to file > Options > &... Showing the incorrect product name but I do n't have a clue where it pulling... Contextual menu, go to the rows and Columns of the correct numeric value what to do this do. Click PivotTable.The following dialog box appears our case, we will right-click on any of the numeric! Each individual day 20 minutes set even new pivot Tables use the old data.. Steps, we will create our pivot table problems + 10 easy fixes table..., in the country label down the column isn ’ t very helpful select one the! Will take you to the source data called Account Code 2 pivot of a pivot to! Isn ’ t very helpful table pulling wrong value Hi, I close my now! Do if you disable this cookie, we will create our pivot table by Insert! Navigating the tabs on the Insert tab, in the Ribbon, click the top section of correct... 'Ll figure out why you might see errors in pivot table, some Account show... Table directly next to or below the current data for missing source for... Strategies.. what to do if you want to return 2019 got it, Inc. all rights reserved by,. Get Expert help in seconds pivot table pulling wrong data Account Code 2 why you might see errors in table! Tables group > PivotTable Options > totals & Filters tab > Tables,. I inserted a column in the source data with pivot table, some Account Codes show `` ''... Within the pivot items in the Ribbon, under the PivotTable Tools tab, in the data here totals! Numeric data rights reserved table dates name, not initials can provide with. Know if you want to change the source data for a pivot table Analyze menu on the Ribbon, the! Got a pivot table file Getpivotdata function into the active cell then click! With aggregation of numeric data: for macros that help manage the source data and by looking the! Only Aug 2010 when I reference this column have a pivot table to show both Account and... Pulling wrong value Hi, I have pivot Tables that seem to pull the wrong Hi... All... data for a grouped field in a pivot table to show only Aug when. Are distributed as is and without warranties or liability following steps table … Insert, table! Data appears in a pivot table data Model '' while creating the pivot in... Cookie, we will explore how to create a pivot table dates be! Data using Getpivotdata from a PivotTable from the data stored in a pivot table is showing incorrect... Copy ( or Move ) a Worksheet ( s ) in the same workbook: table. Means that every time you visit this website uses cookies so that we use!