pivottables

Hello all, I am trying to use PivotTables to summarize and filter data. I have various tables that all do what I want, except for one. I have a list of RMs (People), their Units Under Management, and Total Claim Cost per RM. Some properties have multiple claims, thus repeating data such as Unit...

Hi. I have a spreadsheet with probably three dozen pivot tables spread across multiple sheets. I am sure there is a more efficient way of doing it. I've never gotten around to learning PowerPivot or macros or whatever else I would need to use, so I use what I know. This spreadsheet gets updated...

Hi there I want to use a measure to count the number of times certain words appear in a column and based on that, be able to drill down and look at those records in a new sheet when double clicking on the value. I am able to create explicit measures in the data model, but am not able to drill...

Hi guys, I'm running into a little but of a problem that I'm hoping someone here can help me with. On a daily report that I run I have 8 different PivotCharts from 8 different PivotTables, all from the same data source but displaying different parts of it. I also have one slicer and one...

Hello, I have a project requiring the use of PivotTables in a protected Workbook. I need to code a macro that will allow users to drill down into the PivotTable values, and then will automatically delete them once the book has been closed. I have found plenty of threads demonstrating how to do...

Hi All, I wondering if someone would be able to help. I have a workbook that has a sheet labelled as "Pivots" with the data kept in another sheet called "Calls"...I am trying to find a way that would allow me to update the data in "calls" and for the pivots (named as PivotTable1 to 9) to...

I have two workbooks, each containing a pivot table. The two pivot tables contain the same fields, but the values are different. What I'm trying to do is use VBA to add Fields to "Rows", one at a time. So let's say the pivot tables have 5 fields: Dollars, Account, Activity, Category, Category 2...

I'm trying to add two calced fields into 24 pivot tables across 8 worksheets. It it based on choice of a data validation list in B4 on Sheet 1. The code pasted below works for all of them except for the last 5 tables on Sheet1. I have Field Headers disabled on all Pivot tables. The weird thing...

Hi All, I've written a some code to hide charts and pivots the charts part works perfectly however as i have 12 pivots all feeding from the same source when i try and hide one of them using "tablerange2.entirerow.hidden = true" all of the pivot tables are hidden not just the one selected. I...

I have a workbook with about 30 tabs that each have 6 PivotCharts. Each PivotChart has 12 PivotFields (Values) corresponding to the months of the year. These are basically creating a rolling year effect after data is updated. To do this effect, I need to take the PivotField in .Position = 1...

I'm running into a strange problem, for many years I have used these excel macros and all of a sudden I started to receive errors that only appear on one computer. This macro and pivot issue doesn't exist on any other computer I have tried. So excel was uninstalled and a fresh clean updated...

Hi All, Please note:- I know about slicer but don't want to use and wants a vba macro only. Below is my query I've 3 pivot tables in same excel worksheet. All 3 pivot tables have 5 report filters and out of them 4 report filters are common. I want to use a drop down list from cell b4, b5, b6...

<tbody> I keep getting this error Unable to get the PivotTables property of the Worksheet class from the code below (I used recording button to have these coding from Excel) I'm not sure what is wrong, but any help would be helpful. It hung up at the "<code>With ....End With"</code> part...

I am trying to write a macro to format whatever pivot table I am on in the active workbook on the active sheet that will format an individual data field that will always have the name "dollars". This is the code I have so far: The code I have is as follows: This is try number 1 Sub format()...

I have a line chart that tracks "change per week." Some weeks have negative values, some have positive values. Essentially, I want to specify parameters so that negative values are colored green, values near zero (possibly + or - 100) are orange, and positive values are red. Is there a way to...

Hello, I have a single sheet with four columns (State, City, Start Date, End Date). I would like to create a pivot table that would show the State and City in the rows, a single row of dates on the columns, and then a count of the Starts and Finishes for each State/City combination. Something...

Hi everyone, I created a speedometer chart using a combination of a doughnut and pie chart (in one) based off a YouTube tutorial I found here: https://www.youtube.com/watch?v=f6c93-fQlCs The problem I'm having is that the needle only goes from 0 to 100, but I need it to go from -100 to +100...

Hi all, Pretty straightforward question, I hope. I have a data set that I'd like to see if I can get set up in a pivot table in a custom way. The data is being pulled out a SQL database and looks like this when I retrieve it (dummy data created for example purposes - its actually quite a bit...

I am writing some code to generate multiple pivot tables in excel. My spreadsheet is set up with survey responses to a variety of questions with the question number across the top, and the survey responses below in the column. My problem relates to questions 8, 10, and 13. As you can see in...

I'm getting a "Run-time error '5': Invalid procedure call or argument" when running my code (below). I cannot figure out what I'm doing wrong here. Does anyone have any suggestions? Dim APXPvtSrcData As String Dim APXPvtCache As PivotCache Dim StartPvt As String Dim...