pivot tables excel 2010

I am trying to clear the filters in the pivot tables. I removed the information in the main spreadsheet, but it still remains in my drop down in my pivot tables and is starting to become a big problem. I have tried taking out the report filter field -- removing the main filter than re-adding...

Hi all, I'm struggling to find a solution for this particular scenario I've encountered. Essentially what I want to do is take data from a source table that looks like this: And map it into a pivot table, which would end up looking like this: Any ideas how this is done? I have fiddled...

Hi all, I have been fiddling around with this for a while and it's not something I am even sure is possible! I have a basic pivot table, nothing fancy, using the classic option. My pivot has 2 report filters which of course, dependent on selection, change the data displayed. I would however...

Hello! I am working on a tool that has a "yes" or "no" in the pivot of whether or not an employee has filled out a cell in the source data. I am trying to link it back to the original sheet so the employee can input the info, and thus update and save the pivot (right now it is a "if yes, or if...

I have created a pivot table that will show total sales for our company by salesperson grouped by year and then month. I have it set up the following way: Total Sales as the Value Sales Rep Name(s) in the Column Labels Years, Date of Sale, Contract Type in Row Labels I have a salesperson...

I tried to follow Jon Peltier’s April 24, 2008 post concerning a Dynamic Chart using Pivot Table and Range Names to create a 60-week Dynamic Rolling Chart. The chart generated fine and adds new data but how do I get it to capture only the last 60 weeks? Information: • OS: Windows 7 Enterprise...

I'm having a terrible time figuring this one out. Column B is Date of Training Column D is the trainee name Column F is the instructor name (there are two) Column I is the number of hours of training received by the trainee on that date I need a formula that counts the number of hours each...

Hello, I'm conducting exit interviews for my employees. I have a matrix style questionnaire. <tbody> Strongly Agree Somewhat Agree Somewhat Disagree Strongly Disagree Does Not Apply I received the proper training in order to perform my job effectively. I had the supplies, tools...

Hi Mr Excel community, Hoping someone can help, never done this before so please bear with me. I currently have 2 matching Slicers over 2 separate pivot tables with 2 data sets. I' m very new to writing VBA code and I am hoping someone can help me write a piece of code so when I select a name...

Hello! I'm relatively new to VBA and I'm trying to set a filter to a pivot table so that it filters out any dates before a certain date. That certain date varies based on whatever a user typed into another cell. They way that is set-up is that in one cell, the user will enter the name of the...

I have a table with columns for 1 instructor name, 2 course title, and 3 "was the instructor knowledgeable in their subject area". Values for col 3 are "agree/disagree". I have created a pivot with instructor name as the row label, "was the inst knowledgeable.." as the col label, and "was the...

Hi, I have created a file containing a number of pivot tables which are all pulling data from queries in an Access database. It has been working really well since 2011 and is the source of 90% the required data for reports for our organisation. I have been adding new pivot tables over the...

Strange problem with pivot tables. (Win 7 64-bit, Excel 2010.) I was trying to create pivot tables for a demo on said computer, and found that I cannot move the fields in my usual drag-and-drop way. Each field must be individually right clicked, and then must select "move to column" or "move to...