pivot table 2010

I have created a dashboard from pivot tables of demo data on COVID-19. Initially the pivot tables were from solely created from one data sheet but later other pivot tables (and charts) needed data from a second sheet. Excel created a Data Model to do this (have pivot tables from different source...

Hello, I'm trying to find a seamless way to change the data source file in a pivot table without manually going in and editing the text via Pivot Table Tools -> Options -> Change Data Source. Ideally, I would somehow build a reference using a HYPERLINK-CONCATENATE formula that I build, either...

Hi, I got an annoying issue with Application.ScreenUpdating. It worked fine until I added a secondary subroutine into the code. I tried to look for a solution and already attempted to fix the issue by calling the following subs at the beginning and at the end of the primary and secondary subs as...

I am trying to look at several years of sales data by customer in order to compare year to year sales and possibly monthly or quarterly as well. I have no problem getting it into a pivot table and shown exactly like i want, but the problem is trying to consolidate various customers from the same...

I have the following information in a pivot table. I want to divide '2017 Through May' by '2017 Commitment or 2016 Total' for each row and have the information in a new column titled '% of Giving'. I have tried several different calculated fields but they all sum! How do I accomplish this? I...

Hi i have a sheet with column Total Experience and all these numbers are as follows. 11.03, 0.1,0.11. So my boss wants to know the count of the members as 0-2 years experience how many members, 2-5 years experience how many members, 5-8 years experience how many members,8-10 years experience how...

I have been using a vba code to create pivot tables and remove grand & sub-totals for a couple of weeks now. The subtotal part of the code which was previously working well is not throwing the following error <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo...

Hello - I am using excel 2010. I have a simple list of names, and have added 2 new names to the existing list. My slicer has updated, but the names are now at the bottom of the list on the pivot table and I can't get it to change. I have gone into the options and made sure it says to alphabetize...

I am having a pivot table. I want to export the data to new work book when I click the data in the table. Please help .!!

I have written a VBA code for a Userform that allows current employees to track treatment interactions with patients. The code is working with no problems, but the issue I am running in to is I would like to have the charts generate on their own. I manually can run all the data using a pivot...

Hi Everyone, I have a challenge that is failing to take root in my brain, and I'm hoping that someone will have a great idea, if not an actual solution. Here's my situation: I have a list of charitable membership (about 7000 people) and a list of projects that those members have expressed...

Hi all, I don't even know where to begin with this, so bear with me. I'm using Excel 2010. Ugh! I've tried to format my data, but it's not coming out right, close enough. sorry. Here's my data: <pre> A B C D 1234 5 S M 1234 2 S M 1234 4 S M 1235...

Hi everyone, I need to get some fancy statistic graphs out of my excel dashboard Please see Tabs Dashboard and OG Dashboard in the excel dashboard i have attached. For both, I am trying to get reporting over time and success against iTDD, rTDD and TDD (initial Target Delivery Date columns AF...

Hi All, Im trying to work on a VBA script for updating a pivot table date field based on a reference cell value and am running into some issues. The code below is what im working with. Right now when I run this I get an "Application-defined or object-defined error" with the red text below. Any...

Good morning, I am so close to finishing up some code to refresh a 50+ worksheet workbook, all with multiple pivot tables. The good news for me is there are only 4 source data sheets. At the moment I am designating one sheet "Master Summary" as the sheet with the parent cache/source data...

Hello Message Board. I created a Pivot Table in Excel 2010 that shows Country, Region, Office Sales Rep and Sum of $Sales. I inserted a slicer to to Filter Region and Sales Rep. The problem is that the Slicer shows up, but I'm unable to select anything or even move the slicer to a different...

Hello everyone, I have a pivot table and I'd like to calculate the mode for the week. My data table is arranged by day. The field (in the data table) I'm interested in using is hours. I don't care if the calculation is done within the pivot table or outside. It seems to me that something...

I am new to VBA and have a problem running some code that should create a new Pivot Table. I can get the code to run fine in the sample sheet from the power programming book, but it will not run when I try to use it in a different workbook. I am get a type mismatch error with this code Sub...

Hi there, I'm trying to achieve a pivot table that looks like this: (I have only managed to take the screenshot by copying and pasting the values and then creating % formulae on row 61) I've had a good look at the "Show values as" options, tried having two "Grand totals" by making a...

Thanks for any input on this. I'm trying to make a simple pivot table that is taking data from sheet "5 Month Trending May 15" and putting it onto my Pivot Table sheet called "Errors By Criticality - Pivot". When I try to set the pivot cache range with the create method it's returning a...