pivot table 2016

Hello there, Looking for some guidance on how to code into my macro adding a Pivot Table that has a variable data set. I have the attached coding but does not work if the data set increases/decreases. TIA! Sub BuyerItemPivotTable() ' ' BuyerItemPivotTable Macro ' '...

When I try to save or modify a pivot table in an open workbook, I keep getting this error message "An issue with the Data Model is preventing Microsoft Excel from opening this workbook. Try restarting Microsoft Excel". I have tried previous versions of the same template that have always worked...

Hello, Please see attached image for reference. I have a pivot table that shows the data broken out by Quarters in the columns and Year in the rows. When trying to add subtotals for Division (BAL, KC) the subtotal combines both 2021 and 2022 values instead of splitting them. Basically I was...

Hi everyone, My question relates to dynamically expanding the range on a pivot table when new columns are added as part of a separate pice of code, then adjusting the range of a chart to now exclude a previous column, and include one of the new columns (containing a copy of the previous data...

Hi, I have two data tables with numerous pivot tables of each pivot, I am using a macro to switch data filters across each of the pivot tables. However, when I update the data filter to a new selection the data doesn't always update. When I click on a value in that pivot to drill back it...

Hey; When pressing on a pivot table it will take you to the raw data. Example: Pressing on number 5 for the sum of "misplaced products", it will give you the list of the misplaced products. But when a pivot chart is made out the pivot table if you are to press the pivot chart nothing occurs...

Hi - I have a pivot table where columns are counting values from the raw data. However, one of the values that is being counted is "" (aka just a blank / empty cell that is a result of a long IF statement). Is there a way to exclude this value from the count? I tried changing the formula in the...

Hello; This is a new one for me and I've searched a few hours for a solution and either my question isn't quite worded right, it's not be done (can't believe that), Or I'm having Excel "block" because its so straight forward ...I'm at a loss and could use some help/guidance. I have the...

Hi, I'm hoping to get help with how to compare company data with a handful of other companies. I originally ran pivot table to compare the totals of each company, but was asked to compare my companies data with the average and median number of about 30 other companies in my industry. I will need...

Good day! I've dragged Date to the Filter field. When I open the list, I find the entire list not grouped into years>months>days. Is there something I can do to make it happen?

Work Day values in the Pivot Table do not match the work day values in the worksheet. Some entries in worksheet show less than a full day (e.g: 0.75 of a day vs. 1 day). I tried to use the cell format function the Pivot Table, but that did not work. How do I get Pivot Table to show values < 1...

Hi, I'm getting the "Run-time error '5': Invalid Procedure call or argument at the line below in blue: PT1.ChangePivotCache ThisWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=PTSourceRngFcst, Version:=6) These are the values of the cells listed in the code: G24 =...

Excel 2016. I have a pivot table that is connected to a table that refreshes from an SQL Server Connection. For some reason all of a sudden Everything is blank. I check the Data Source and it is still connected to the Table by name,but now even if I choose the table and create a new pivot table...

I have a very large spreadsheet of data with dates (confirmed that they are proper dates to Excel as opposed to strings) that I am trying to group via VBA. When I run the code, I get an error. With ptTable ' Set the row fields .PivotFields("REALDATE").Orientation =...

Hi all, I have looked online but can't seem to find an answer to this. I have currently filtered the date by specific year which looks like below. What I am trying to do is use a slicer so that I can choose between dates and also get a text return linked in but I cannot seem to figure out how...

Hi everyone, I'm new to this forum. I need some help with pivot tables: I'm trying to consolidate payments Ids together, specifically payments which have the same ID but different payments need to be combines and totalled into one. I done a head-start with pivot tables. I comparing and...

Someone sent me an Excel file containing a single pivot table. A dozen fields reside in the pivot table field list within the ROWs box. One field resides in the VALUEs box. All of the ROW data fields (names) appear in the pivot table as columns, including the single 'value' field. I've never...

Hi all, The purpose is to pull through large .csv into Pivot Table for manipulation and aggregation, and be able to change the sources of data fairly intuitively. the .csv is saved in separate location. However, when I try to change the sources of the .csv that the Pivot Table is linking to, if...

If there is a previous thread for this topic, please direct me to it. I have a large table (both in columns and rows). In each row/record, there are three name fields. The same name could be in any record, in any of the three fields. I need a way to put all of the names from those three fields...

My spreadsheet captures information about military basic training - the trainee's name, the squadron number, the flight number, start/end dates, etc. A flight can have more than one TI (Training Instructor), so in any given record, there can be TI1, TI2, and TI3, which are listed by last names...