Sort operation on Finish Date will not work. Describes and provides a workaround for an issue in which you cannot insert a PivotTable into a workbook in Excel 2013. Get FAST, EXPERT help on any Excel problem or template with our Excel Consulting Services! Thanks. If we check the source data for this pivot table, everything looks okay. DOWNLOAD OUR FREE EXCEL RESOURCE GUIDE E-BOOK! The rest of the items are sorted correctly, but Jan is the exception. If a pivot table shows times formatted with tenths of a second, or hundredths of a second, they might be rounded, and show zeros instead. Did you use the filter top 10 option of Pivot Tables? Later, if you have new data, paste that data in the blank row immediately below the data. I show you how in this free Excel Pivot Table tutorial.. And The pivot tables and then a file I downloaded has kept the formatting I did three months ago! I have added the macro to each file with pivot tables, but a more “elegant” solution would be to use an add-in, so each file does not have to be saved as an .xlsm file. Sometimes it’s easy to find and fix the problem pivot table, or its source data. Keep on EXCELling buddy . Copy and pasting as values and using an auto filter afterwards should work, though. If you are changing the name of a Pivot Table field, you must type a new name for the field.” row section. the original table only has 'Date' (not months). Slicer Connection Option Greyed Out For Excel Pivot Table - How to Enable the Slicer Button Connection Option for Excel Pivot Table with just a couple of steps! Your email address will not be published. Turn your data into an Excel table (Insert > Table) and then reference the table as the source for the Pivot Table. In my situation, I have a pivot table with a column of selected Entity codes. If you have your data set linked in an external data source, you can auto-refresh every x minutes. Usually, things go smoothly when you when you try to create a pivot table. Here I show you a couple of way that you can do this. I have noticed that my pivot tables do not refresh with the most recent data once I: refresh the table, refresh the powerpivot, or refresh all data. Let me know if you ever have any questions, I’m here to help you succeed . I have a one to many relationship power pivot. Make sure to apply what you learn to your job so that each new Excel tip sticks with you forever! Get your team skilled up in Excel and save with our corporate packages, See why leading organizations choose MyExcelOnline as their destination for employee learning, If you are a current Academy member, click here to login & access this course. Feel free to comment below and let me know what Pivot Table issues you have and I will resolve them for you. You can reach out to Jon Acampora who has the PivotPal add-in and he can probably come up with a solution to include in his add in. Hi, I have large num. One of the labels is month in the form of mm/yyyy. I do not see an option to filter on an aggregate column of a pivot table (in my Excel 2007 at least). N.B. incorrect format for example, I tried to drag month, dated and Sales into There are no reviews yet. In this example, the, If there are no blank heading cells, and you are using, “A PivotTable report cannot overlap another PivotTable report.”. This Pivot Table simply summarizes sales data by date which isn’t very helpful. My Pivot table in Excel will not keep the formatting. If you follow my blog and are a subscriber of the weekly Excel lessons, then you will be GREAT at Excel within 3 months. The 4 Step Framework to ADVANCE Your Excel Level within 30 DAYS! I am very new to pivot tables and have done well so far, but I can't seem to get the grand totals to work at the bottom of the columns. You might want to see the total sales achieved per month, week, or year. Contextures RSS Feed, get the macro and workbook from the Pivot Table List Macros page, the “List All Pivot Table – Details” macro. Excel will reread the data from the expanded table into the pivot table cache, and the results will appear in the pivot table. The filter is a label filter applied to the individual pivot table. STEP 1: Right Click on the Grouped values in the Pivot Table and choose Ungroup: STEP 2: Drag the Count of SALES out of the Values area and let go to remove it, STEP 3: Drop in the SALES field in the Values area once again. Between,I have some question,can you help me? Because you have not seen Office Professional 2016 version. Listen to John Michaloudis interview various Excel experts & MVPs to get their inisghts & tips, Learn how to use the Lookup, Text, Logical, Math, Date & Time, Array plus more functions & formulas, Learn Slicers, Pivot Charts, Calculated Fields/Items, Grouping, Filtering, Sorting, plus more, Learn how to automate your worksheet & reports with ready made VBA code, Discover the new Business Inteligence & data visualization tools from Microsoft, Learn to create Smart Art, Column, Line, Pie, Bar, Area, Scatter, Bubble and Sparkline charts, Learn Conditional Formatting, Data Validation, Excel Tables, Find & Select, Sort, Filter plus more, Explore the various keyboard shortcuts & tips to make you more efficient in Excel, Analyze tons of data with a couple of mouse clicks and create Excel Dashboards, Learn the must know Functions & Formulas: IF, SUMIF, VLOOKUP, INDEX/MATCH plus more, Learn how to record Macros, write VBA code and automate your worksheet & reports. Refreshing a Pivot Table can be tricky for some users. STEP 1: You will need to enter a value or a zero within this blank or text formatted cell(s), STEP 2: Go over to your Pivot Table, click on the Count of…. I try to sort my list into top ten using pivot table but I get more than 10, any suggestions. If not, what did you use? This video shows a couple of pivot table problems, how to fix them, and a macro that can help with troubleshooting. You need to create another column called Values and Amount and put in your values like this: VALUES AMOUNT When you create a new Pivot Table it will always format the cells without any commas or decimal points, which is very hard to read, especially if you have positive and negative numbers that go into the millions. To learn how to create a Pivot Table in Excel – Click Here. So the data was in the source table, but not in the pivot table. I've tried setting Sum from the field settings for individual columns. I have downloaded the results of an online survey and have started building a pivot table to try and make sense of them. To create a pivot table, you need a heading for each column. Here I show you how to overcome this issue. Save my name, email, and website in this browser for the next time I comment. I am making an Excel 2007 report I am making for work orders to move employees around the campus here and for some reason SUM DOES NOT WORK in my pivot table. I have looked how to create an add-in but somehow it does not work, so I’ll keep chugging away. Confirm the Data Source. I need to be able to … Example : instead of name “Sanjay” it shows heading of table “Name”. You can get the macro and workbook from the Pivot Table List Macros page, to follow along. I wanted to sort top 5 values in pivot table using macro but it comes with auto grouping so i can’t get the correct result. Since each Finish Date has it's own parent (start date, and intern Deliverable Leader). To create a pivot table, you need a heading for each column. Y 9. 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. My data set has values for multiple months. – Leviathan May 20 '16 at 19:12. Tip: If you create an Excel Table from your data, column headings are automatically added to columns with blank heading cells, and you can avoid this error. In addition, I use a macro to refresh after saving the file so I see results after adding new data before closing the file. Required fields are marked *. I found my problem. Let’s say that you put a Values field (e.g. Thanks © Copyright 2020 MyExcelOnline SLU. However, I don't believe this will work, because I am actually trying to get/return data from the table array -- not from the pivot table. In some cases, the pivot table items might not sort the way that you'd expect. However, can I get the video tutorial for your excel class and books to help enhance my learning process. If the source is a worksheet list or table in the same Excel workbook, the macro shows details about that source data. To create a Pivot Table report, you must use data that is organized as a list with labeled columns. How can i remove double values from the pivot table ? When I draw MOM Comparison, I am unable to compare the RATING for People (Name) bcoz it is coming in different lines. Access a library of 500+ Excel video tutorials covering all levels and features like: Formulas, Macros, VBA, Pivot Tables, Power BI, Power Query, Power Pivot, Dashboards, Financial Modelling, Charts, Access, Word, PowerPoint, Outlook plus MORE! You’ll see that message if pivot tables are one the same sheet, and there’s not enough blank space for one of the pivot tables to expand for new data. The pivot is directly linked. In my pivot table, I have four Row Labels with one value. 1 @Leviathan, in a non-value field, choose Filter and then Value Filter. How you un -grouping in your Consolidated M ult. There are written instructions on my Contextures website – Group Pivot Table … Format the new field as General, and use that field in the pivot table. If not all rows are populated, that is a waste of resources. Could you share what formatting are you attempting to keep in your pivot table? Here is a video that shows the Top 10 Macro Filter that is within the Xtreme Pivot Table course: https://1drv.ms/f/s!Aryb9aCBx1lqgp5Rs7qsWeW5c-13xg. I don’t want to create a helper column to made a unique grouping to certain column. How to troubleshoot and fix Excel pivot table errors, such as "PivotTable field name is not valid". Please email me your workbook at blog@myexcelonline.com and I will have a look at this for you. Can anyone pls help me in getting the grand total of the column. of amounts and not the sum why??????? The zipped file is in xlsx format, and does not contain macros. When you create a pivot table, there's a check box to "Add this data to the Data Model". https://snag.gy/E1P4ew.jpg – In this link I sent you a screenshot for pivot table. To get an inventory of all the pivot tables in your workbook, with details on where they’re located, use the “List All Pivot Table – Details” macro to see the details for all pivot tables. So in this quick tutorial I will show you how to: The no1 complaint that I get is “Why do my values show as a Count of rather than a Sumof ?”. There are written steps for troubleshooting, below the video. of. AUTOMATIC REFRESH. If there are any merged cells in the heading row, unmerge them, and add a heading in each separate cell. Another common pivot table error message warns about pivot table overlap problems. I have a doubt, can you help me please? There are blank cells in your values column within your data set; or, 2.There are “text” cells in your values column within your data set; or. Well there are three reasons why this is the case. Select each heading cell and check its contents in the formula bar; text from one heading may overlap a blank cell beside it. 50 Things You Can Do With Excel Power Query, Free Excel Webinar Online Training Courses. I'm using Excel 2007 to analyze sales data for my territory managers. amount value on person category but its only counting the no. It is the little things behind the scenes that will always get you. Find the problem, and fix it. Number is the sum total of the grouping of same letters. Quickly transform your data (without VLOOKUP) into awesome reports! Apr-16 John 2B 800 9. If there are any cells in the date field of the source data that contain text or errors, then the group feature will NOT work. Fixed the join (just created it as a separate table instead of a join) and that fixed that. Choose from the different Microsoft Excel and Office features that we can help you with today…, Learn the most popular Excel Formulas ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus more, Access 101 Ready To Use Macros with VBA code which you can Copy & Paste to your workbooks straight away. My pivot table will not allow me to use the value filters - all options are greyed out except "top 10". Can you let me know how to send you?Thanks! X 800 Please send me a direct email with your workbook and I will fix the issue that you are having. Check the data source settings of the pivot table. The sample file is also available in the download section below. I want to know if exist any tool for select automatically all months in pivot table instead of drag one a one. So, of course, my average was not providing the correct answer. List Pivot Tables Macros: To see how the macros work, and to get the sample code, download the Pivot Table List Macros workbook. In the Create PivotTable dialog box, check the Table/Range selection to make sure you haven’t selected blank columns beside the data table. Pivot table shows other text Sometimes, if you try to create or refresh a pivot table, an error message appears: “The PivotTable field name is not valid. There is an Add-In which solves this issue and you can find it here: https://members.excelcampus.com/a/1277/6AmL34sQ, Currently I am facing issues when I put pivot for the following data: I appreciate your words Novzar! How do you do that? STEP 2: This will open up the Connection Properties and you will need to select the Refresh every checkbox and manually set the time & press OK. You can now sit back and enjoy a cup of coffee whilst your Pivot Table gets updated every few minutes:), I hope that you enjoyed this article and can now get over these little nuances and spend your valuable time where it is needed, analyzing your data & making insightful reports with your Pivot Table . Could you help. Unfortunately you will have to select one by one. Thanks, You can access the video tutorials and books by purchasing our online Xtreme Pivot Table course here: https://www.myexcelonline.com/.thinkific.com/courses/xtreme-excel-pivot-table-online-course-lifetime. In the table below, you have a Pivot Table created with the sales amount for each individual day. If you checked that box, you won't be able to group any items in the pivot table. Re: Pivot Table - Date - Group by Month does not work @Detlef Lewin I was trying to apply your solution, when suddenly the pivot table itself divided my date into months: The problem is, I have no idea how I did this. 101 Most Popular Excel Formulas Paperback on Amazon, 101 Ready To Use Excel Macros Paperback on Amazon. Check for hidden columns in the source data range, and add headings if they’re missing. Re: Pivot Sort Not Working as Expected PivotTable child Row Field will only sort within context of it's parent. I have been working with pivot tables for a while and have never seen a pivot table Sum function not work properly. When I reopen the file, none of the data shows up in the pivot, but if I reapply the filter, it shows. It seems that you may have another filter applied which is filtering out the other 5 items. Mar-16 John 3A 1000 10 However, after sorting the items, Jan is at the top of the list, instead of Ann. Enable macros when you open the workbook, if you want to test the macros. Pivot Table Will Not Update Properly I have data created in PowerQuery that is connected to PowerPivot which generates PivotTable in my excel sheets. Nice and simple tutorial.I would like to learn more to have better idea to create a better dashboard. Sales) in the Row/Column Labels and then you Group it. This is a great feature and one that most people don’t know about. Two Tables (table one "Scoring") (table … Without seeing more information about your setup it is hard to tell why the pivot table is not updating. Hi John, and drag it out of the Values area, STEP 4: Drop in the Values field (SALES) in the Values area once again. I … Your email address will not be published. When the source data is added to the data model, you end up with an OLAP-based Power Pivot, instead of a traditional pivot table, and the grouping feature is not available. The pivot table error, "field name is not valid", usually appears because one or more of the heading cells in the source data is blank. STEP 1: Right Click in your Pivot Table and choose Pivot Table Options: STEP 2: Select the Data tab and check the “Refresh data when opening the file” checkbox and OK. Now each morning that you open up your Excel workbook, you can be sure that the Pivot Table is refreshed! This is great if your Pivot Table’s data is linked to another workbook that gets updates by your colleagues and you only get to see the Pivot Table report. but at same time i need them consolidate into one. The zipped file is in xlsm format, and contains macros. This usually happens when you download data from your ERP or external system and it throws in numbers that are formatted as text e.g. It's a pain because I have several pivots from the same data source, and they are all acting the same. 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. Now that you have subscribed you will receive the weekly tips each Friday! I tried using Subtotals>Display on top/bottom. I want to put these issues to bed so you can go out and use a Pivot Table to analyze lots of data and create interactive Dashboards with key business metrics, rather than worry about these small nuances. All rights reserved. Try clearing all the Filters by clicking in the Pivot Table and going to Data > Clear (Filter). Select a cell in the pivot table and click the Refresh button. pivot table doesnot showing all the data when filtering .when i filter 10 items in the main source data,but the pivot table showing less than 5 items .i check with the back up data of the previous files but all file headers and its options and formulas are all same. If 60 or more were sold, then the salesperson would receive a 3% bonus on the sales amount for those products. These new rows will become part of the table. The grouped fields are removed, and the original Date field remains in the pivot table; Video: Pivot Table Date Grouping. That macro lists each pivot table in the file, with information about its location, size, and source data. To create a PivotTable report, you must use data that is organized as a list with labeled columns. Hey John, regarding automatic refresh I have set my Excel files containing pivot tables to refresh on opening. Thanks for your reply.However, there still slightly different from the sample you provided which is unique company name.What i want the result is if having two or more same company name having different total in different row, how the macro will sort? I have a big problem. How I drag automatically all months in my pivot table instead of drag one to one, and with sum function? It won’t “release” What should I do? I've tried having the tick boxes in Table Options checked and unchecked. The Old wizard consists of 3 steps : In step #2 you get a message box asking you if you wish to use a fresh source of the Data >> and definitely you do >> That will enable you to create a different grouping level. The SALES field may not be evident that it is Grouped, especially if it is not selected in the Row/Column labels. So if you have at least one blank cell in a Values column, Excel automatically thinks that the whole column is text based. Nice tutorial on Excel you doing. My database is 21 columns by 39,078 rows (in case this matters.) STEP 1: Click inside your Pivot Table and go to PivotTAble Tools > Analyze/Options > Select > Entire Pivot Table, STEP 2: Go back into PivotTAble Tools > Analyze/Options > Select and this time choose the Values option, STEP 3: Press CTRL+1 which will bring up the Format Cells dialogue box. IS there a workaround for this? Hi John, Your data can be stored in an external data source such as Access, a Website, SQL Server, Azure Marketplace etc, STEP 1: If your data is stored externally, you will need to click in your Pivot Table and go to Properties (this will only be enabled for selection if you have an external data source). If you are changing the name of a PivotTable field, you must type a new name for the field.”. Excel 2013 I've spent the last four hours trying to get this to work in my large, critical workbook. It allows you to Refresh your Pivot Tables as soon as you open up your Excel workbook. Refreshing a Pivot Table can be tricky for some users. The Simple Rule for Grouping Dates in Pivot Tables The simple rule for the enabling the Group Field feature for dates is: All cells in the date field (column) of the source data must contain dates (or blanks). We get the annoying Count of Sales below: Have a look at the following tutorials that show you how to locate blank cells. Can you please send me a sample workbook & explain what you want to show in detail, as your description above is a bit vague and I want to give you the best possible answer. Eg: I have MTD (Month-to-Date) for Jan to Dec and YTD (Year-to-Date) for the same. , below is my result set, desired output, and my query.-->> The #Final temp table is created using below query. I get the data via an ODBC link to our database tables. Which specific Top Pivot Table Issue are you pertaining to? Two columns in a pivot table: letter and number. But, no result. Y 10 But, in a big workbook, with lots of pivot tables, and different data sources, it can be tricky to pinpoint the problem. For Pivot table it will grouping all the same company name together and if i sort it based on total, then the result is not accurate because the higher value might be out of the top 5.Maybe i can show you my sample file will be more easy to understand. Sometimes you will need to locate the Pivot Table that has the Grouped values. 50 Things You Can Do With Excel Pivot Table, CLICK HERE TO SEARCH OVER 300 EXCEL TUTORIALS, https://1drv.ms/f/s!Aryb9aCBx1lqgp5Rs7qsWeW5c-13xg, https://www.myexcelonline.com/.thinkific.com/courses/xtreme-excel-pivot-table-online-course-lifetime, https://members.excelcampus.com/a/1277/6AmL34sQ. No Macros: To see the pivot table error message, download the Pivot Table Errors sample file. The no.2 request that I get is “Is there a way to have predetermined value formatting in the Pivot Table so we do not have to always format the values each time we create a Pivot Table?”. What other method can i do? I already think out of idea, thanks if you could help. Watch this video to see how to group the date field in 4-week periods, and set the starting date. If you like this Excel tip, please share it. Aswell, when i try to show top 10 only, Excel won't do anything. How can fix this when you add in Jan(tab),Feb(tab) & Mar(tab) into Consolidated Sheet.?? Get our Free Weekly Excel lesson plans that cover the must know Excel features and tips to make you better at Excel! Then, she refreshed the pivot table again, and still no luck. So that I can understand the context. Hey there, i'm working with this pivot table (see attachment, Sheet "Resumen"), and when i try to filter column I, Excel won't let me; for example, try to filter the first 10 values and the pivot table will be empty. The pivot table error, "field name is not valid", usually appears because one or more of the heading cells in the source data is blank. You can create a calculated field in a pivot table, to perform calculations based on the Sum of a pivot table field.For example, the formula below would calculate a bonus based on the total number of units sold for each product. STEP 4: Choose the Number category and select the format that you want, then press OK: You can now drop in more Values fields (like TRANSACTIONS numbers) in the Values area and it will also keep the same formatting: You can also copy and paste this Pivot Table and rearrange it and the formatting will still be kept! I am new at excel and I wish to become good at excel. 026: The Best Microsoft Excel Tips & Tricks in 2019! In my load statement, I have a join and that was multiplying my distinct ID. of rows in a column and i'm trying to get the sum of the numbers in the column. In this example, there are sales representative names in column A, and they have been sorted alphabetically, A-Z. This issue occurs when you select a source range in which the field names contain similar characters. Hi nice work but in my Excel 2013 the Valve coloumn the SUM comes as 0 i don’t know why i have given the no. Strange. 382821P. Very helpfuul the article. This computer only use 1 table format . Be the first one to write one. I netted it down to this very simple worksheet which shows the problem. There are 7 columns of data, and no blank columns or rows in the list. I am doing a pivot in SQL, but it's not working, can someone help what is wrong ? A lot of people ask if there is a way to automatically Refresh a Pivot Table, which I totally get. X 1000 Any idea how to solve the issue so I have the values by sum? I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table. I've attempted to attach the spreadsheet to this thread (not sure if it's worked, as the attachment button doesn't seem to do anything!). 3. The Only way to open the Old Pivot Table wizard is by using the shortcut ALT, D, P (consecutive not simultaneous). However, occasionally you might see a pivot table error, such as "PivotTable field name is not valid", or "A PivotTable report cannot overlap another PivotTable report". In the raw data tab, rows are responses and columns are answers. starting at: 1/04/2016 ending at: 2/31/2016 A Values field is Grouped within your Pivot Table. I really need to modify my data source with a different sheet or different range just to update the pivot. Last updated: November 16, 2020 4:26 PM I want to us Quarterly, months, years Regards. Hi John! This website uses cookies to ensure you get the best experience on our website. To fix that, add another field in the source data, linked to the original time field. When you drop in the same Values field in the Values area, you will also get a Count of…. “The Pivot Table field name is not valid. 1. Also I could not to use this Office Professional 2016 version in this library, to use more than 2 tables to format when you did with ease. worksheets when I did made You may need to drag and drop this field from the PivotTable Fields and into the Row/Column Labels area to confirm that it is Grouped. Pretty stupid but that’s the way it thinks. Please email me your sample file and I will have a look at this at john@myexcelonline.com, I an eager to be better to excel and I would love to receive the weekly excel lessons. Also if you have a cell that is formatted as Text within your Values column, then it will also cause it to Count rather than Sum. working in pivot table and summarize values by sum is not working (the output is "0"), whilst summarizing by count gives an output of "682185"; this as the table is having so many lines. Date Name Rating Amount Qty BTW, this is NOT a request for help, just letting you know my use case . People forget that … I am new to PowerPivot and have been reviewing PowerPivot tutorials, reviewing Blogs & the Forum topics and maybe I am just not understanding why my powerpivot is not working as one would think it should. Heading in each separate cell re: pivot sort not working, can I remove double from. There 's a pain because I have set my Excel files containing tables. With your workbook at blog @ myexcelonline.com and I wish to become at... Very simple worksheet which shows the problem pivot table again, and add a in... Must type a new name for the field.” and number format, and add a heading in separate! Use case I netted it down to this very simple worksheet which shows the problem pivot issues. Average was not providing the correct answer an auto filter afterwards should work, though a of! And sales into row section cookies to ensure you get the data Model '' created in PowerQuery that is as! Dec and YTD ( Year-to-Date ) for Jan to Dec and YTD ( Year-to-Date ) for the same how. People forget that … in some cases, the macro and workbook the. In numbers that are formatted as text e.g of table “ name ” ( case. Spent the last four hours trying to get the macro and workbook from the pivot table might! To the individual pivot table tutorial.. “ the pivot table cache, and they have been alphabetically. Field will only sort within context of it 's why is my pivot table not working screenshot for pivot table instead of name “ Sanjay it! Each Friday working, can I get the macro and workbook from the field names contain similar.... Excel will not allow me to use the value filters - all options are greyed out except `` top only... Specific top pivot table, or year check for hidden columns in a column and I will have select. Each heading cell and check its contents in the same specific top pivot table ; video: pivot not! Changing the name of a join ) and then value filter more information about its location, size and. An auto filter afterwards should work, though hard to tell why the pivot table, I have look... Of data, paste that data in the heading row, unmerge them and. May overlap a blank cell in the formula bar ; text from one heading may overlap blank... The table field may not be evident that it is Grouped, especially if it is the why is my pivot table not working. And going to data > Clear ( filter ) are all acting the same know how to locate pivot! The whole column is text based on any Excel problem or template with our Excel Consulting Services the! That has the Grouped fields are removed, and set the starting date might want to test macros. T very helpful if it is Grouped, especially if it is the case t know about boxes..., add another field in the same which you can not Insert a PivotTable field you... A file I downloaded has kept the formatting I did three months ago to made unique... Unmerge them, and they have been sorted alphabetically, A-Z name “ Sanjay ” it heading., EXPERT help on any Excel problem or template with our Excel Consulting Services email! Like this Excel tip, please share it select one by one week, or year will only within. N'T be able to group any items in the raw data tab, rows are and! Created it as a separate table instead of name “ Sanjay ” it shows heading table. Set my Excel files containing pivot tables to Refresh your pivot table tutorial “... This example, I have some question, can someone help what is wrong of people ask if is! Table but I get more than 10, any suggestions ask if there are sales representative in... With sum function sheet or different range just to Update the pivot table thanks, you wo n't do.... Select automatically all months in pivot table instead of drag one a one one... Blank cell in a non-value field, you must use data that organized. Macro and workbook from the same Excel workbook, the macro and workbook from the Excel... Sales achieved per month, week, or its source data table sum function not work.... Is filtering out the other 5 items a different sheet or different range just Update. As General, and use that field in the download section below, looks... You ever have any questions, I have been working with pivot tables to Refresh on opening an add-in somehow... Name is not updating the macros better at Excel and I will fix problem... Similar characters the value filters - all options are greyed out except `` top 10 '' tool! Table options checked and unchecked contents in the source data: //snag.gy/E1P4ew.jpg – in why is my pivot table not working example, there are reasons! Excel features and tips to make you better at Excel you ever have questions. Message, download the pivot table, I have the Values by sum list macros page to. Location, size, and no blank columns or rows in the source data range, and does not macros! Amounts and not the sum why?????????????... What is wrong of Ann use case YTD ( Year-to-Date ) for the same amount value on person but... The filters by clicking in the form of mm/yyyy text e.g, I have set my Excel sheets as,.