pivotfield

Hi all, Using Excel365 My code is retuning an error Not sure why? I am trying to add 4 Row Fields to the Pivot Table. The first 3 are added to the Pivot, but not the 4th. I see the column in the data source I can manually drag the field from the Field List to the Rows Fields Not adding the...

Hi Team, I have below code where I am creating new worksheet for each director in the list and named the worksheets to the directors name. Sub test() Dim a As Variant Dim i As Long Dim ws As Worksheet a = Cells(2, 2).Resize(Cells(Rows.Count, 2).End(xlUp).Row - 1) For i = 1...

Hi there, Leveraging some posts online, I have created a macro that should allow the user to make filter selections on one sheet while having the actual pivot table on another sheet. Sub Update_Pivot() Dim ws As Worksheet Set ws = ActiveWorkbook.ActiveSheet Dim wsname...

I have recently converted a project to use the Data Model and Power Pivots. This project has numerous Pivots on a template. The Pivots need to set the value of a PivotField to change the view between various departments. When I recorded the actions, I got a line that looks like this...

I am trying to use the following macro to automatically update a pivot table when something changes (just the barebones changes below) : Dim pf As PivotField Dim pt As PivotTable Set pt = Sheets("Top 10 Pivots").PivotTables("TotalUS") Set pf = pt.PivotFields("[MonthOnlyDateTable].[Fiscal...

Hi, I modified the following code to refresh a set of filters in a pivot table based upon the values that are placed in cell range. I thought this code could work but I'm getting a "Sub or Function not defined" error. Any idea where I could have messed up this code? Do you think this will...

Hey everyone.... I'm looking to create a macro that will update a PivotTable filter to the most current/recent date -- this date will be end of month (so a 01-31 for example, these dates are formatted like -- 2018-01-31T00:00:00). The idea is that the code will reference a cell within my...

Hi all, I have built a pivot table using power pivot; it's set to tabular view so that Customer Code and Company Name are in columns A and B. When a user clicks on the Company Code or Company Name then the Macro needs to jump to the P&L Sheet and change the customer Code to match... Option...

Hi, I'm building a macro right now that reads some filters a pivot table based on data entered in another master workbook. This file has to work with multiple (10+) different pivot tables, which are generated daily, and all of which have different Pivot Fields available. I've gotten to where...

Hi, As the title says I am trying to have my pivot table use the format for each field that its source data uses. I have used this code to change the names of each of the pivotfields in the pivot table and would preferably like a way to do this using the for loop indicated below when changing...

Hi, I have been looking for a solution to this for a while, I have found things that come close but when I try to emulate it, it fails. I have a file that I run at any given time that has 13 months of financial account balances. Those 13 months change each month based on the current month. For...

Hi, I have a pivot table with two columns: Code and Quantity. I want to loop through the Quantity column and hide all values = 0. I can do this easily by incorporating this into my code: pt.PivotFields("Code").PivotFilters.Add _ Type:=xlValueDoesNotEqual...

I have this large macro that when it is contained as one large macro the code runs perfectly without issue. Sub RSLDashboardtesting() Dim APPSPD As Worksheet With Application .ScreenUpdating = False .Calculation = xlCalculationManual .DisplayAlerts = False...

Hello I have an issue that i have been playing around with my self for quite sometime now. I found a code that should work but for some reason it is not working and I haven't a clue why. Any help would be appreciated. Goal : Code that will take a drop list and modify the pivot filters on...

Do pivotFields have a property to let me not do any subtotal at all? For example, I have 'order by date' and 'item' as my rows, with 'amount' and 'deliver by date' as my values. I want to total amount, but totaling the dates doesn't make sense to me. I've been going with 'min of deliver by...

I found some VBA code to separate a detailed list based on a pivot table filter. I modified the code from creating a separate file for each pivot item to creating a separate tab. That part works great. The detailed list is tasks by employee and the separated filter is director. The detailed...

Quick question- I'd like to put in some code to swap the first field item in the row label section. I can do this by specifying the specific field I want to remove, but how can I get rid of the current "first field" if I don't know what it is? So I might have my Row Labels as: Name State...

Hey guys, I have the following problem. I have a Pivot Table that is linked to an Access Database. In order to get the required results for my management report I need to remove and drop a lot of column, row and page fields which requires a lot of time. I have recorded and tweaked over 40...

When I record a macro to remove a data field from a pivot table, I get this: ActiveChart.PivotLayout.PivotTable.PivotFields("Sum of orders").Orientation = xlHidden I then return the pivot table to the exact state it was in before I recorded the macro and run the exact code that was recorded...