pivot 2010

I'm a little puzzled, I'm sure because it's that I'm not understanding something correctly. Say that I've made a pivot table from the following data: Month Company January Company A January Company B February Company A February Company B February Company A February Company B...

Hi, I have created a Pivot Create Code which worked Correctly. But Now the Data i am trying to use the code is of high columns and rows. Is there any solution on correcting this code. which must work in larger data too. Sub EGPivotCreate(DataSourceSheetName As String, DataSourceAddress As...

Hello! I’m trying to find a formula for an Excel 2010 workbook that will identify the number of unique ids in one column that meet a condition in a second column then returns a count of 1 in the cell for the first instance then 0 for each recurring instance. Ultimately the count columns will be...

Following on from another thread, I'm working on a report with two pivot tables where I need to have some way of comparing the data from the first pivot with the second one to see if it matches or not. If I was producing this analysis for myself I would normally just paste special values both...

Hi, I was wondering if it is possible to be able to change the option within a filter for a pivot table without having to click on the filter option itself. What I would like to be able to do if it is possible, is to select an employee name or ID via cells that are not part of the pivot, and...

Ok, so I have a Pivot Table; the row labels are Year > Period > Journal ID. I have 2 years 2016 and 2017 when I try to expand say period 2 in 2017 it also expands period 2 in 2016. I don't know why this is happening I haven't seen it done before but it's driving me crazy and I need it to stop...

I have several pivots controlled by slicers. When I pick a filter the columns show ####. I cannot make it into a dashboard because I have to keep formatting the columns. I tried changing the format options in the pivot table but that did not work. The pivots hold time values if that matters.

I have created a pivot table that looks like this: Training Program Total Number of People Assigned Number of People Already Completed I need to show the percentage acquired (completed/total number) I know this should be simple, but I'm not very skilled in pivot tables and I'm really...

Hi All, I am building a pivot table using power pivot. In the power pivot data model, i have created various 3-4 measures. My question is when i create a pivot table normally we drag measures into pivot table value feild. It could sum of sales, average age of salesperson, number of...

I have a list of about 1000 names that fall under 1 of 2 categories: Home Owner and Renter. Approximately 100 or so people on this list fall into both categories. Out of these 100 or so people, a number of them have multiple homes and multiple renters. I have this data in my pivot table and I...

Hi, I built a pivot table in Excel 2010 on basic data to count # of employees by state. I then used the "show values as" feature to show the count as % of the grand total. The next step is to apply these percentages to total revenue to allocate 2015 revenue by state. The question is can I...

I have an issue with my pivot table because it is not recognizing all same text entries as being the same. As a result my pivot table shows duplicate data for the same entry. I can find lots of threads about this issue when the data is a date or number but I cannot find any information for this...

I have set up a slicer that controls 2 different pivot tables attached to the same data, very simple basically synchronizes the tables based on user selection. After the selection I would like the to fire a macro that re-sizes columns to data for best fit. if I turn on auto-size columns...

I've seen many posts about retaining the pivot table formatting when pasting values to unlink it from the source. The paste special values does not work. I've tried using the clipboard to paste and it worked one time. In the same workbook attempting to copy and paste the values and formatting...

Hi everyone, I'm using vba to filter a series of Pivottables on different worksheets within the same workbook. Most of these Pt's don't really form a problem. However for my reports i want to be able to set the YTD months (in reportfilter) to the same month i'm defining in NewCat 1, 2 or 3...

I have a table that fills in automatically from a pivot. The pivot is created from an Access database. It has lookups to the pivot that are dynamic instead of absolute so that the table changes based on what is selected. From this: =GETPIVOTDATA("Number",$A$23,"Area","A","Priority","1") to...

Dearest Excel Magicians, Wizards and Gods I have a report that was made some time ago (P&L report). It grew to 60mb at this point, and with all the pivots, caluclations etc - well, it got very obese, slow and lazy. I figured out, that I will move all the source data to MS Access database. But...

Hello, I am trying to create a Pivot Table that will pen data into table format. When I click on the number, it opens the proper data, but it is not automatically turned into a table. I hope this makes sense, but just in case- here is my reasoning. I am recording a macro, and would prefer...

Good Afternoon, I asked this question about a week ago and never got any responses, so I thought I'd ask it one last time. Any help is greatly appreciated, as this one is driving me nuts. In short, I have a multi column pivot table calculating student throughput for classes we teach...

I have a sheet that list orders going out for each day of the week and I have added a pivot table to summarize the quantities of each product for a given day. Since this is a template I would like to have a blank sheet with the various data fields for the day and off to the side have the pivot...