pivot 2010

  1. M

    Run Time Error 13 type Mismatch in Pivot table

    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...
  2. D

    Identify unique items in a column based on a specifc condition in another column to return 1 or zero

    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...
  3. S

    Matching data from one pivot table with a second pivot table

    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...
  4. S

    Choosing a different filter option for a pivot table outside of the pivot table

    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...
  5. B

    Pivot Table STOP Mimic

    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...
  6. D

    Stop auto fit when using slicers

    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.
  7. D

    Pivot Table Calculated Field

    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...
  8. J

    Need help with automatically changing pivot table measure in power pivot

    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...
  9. R

    Filtering out all 0s on 2 Pivot Table Fields

    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...
  10. B

    Pivot Table-Calculated fields

    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...
  11. D

    Pivot Table is not recognizing same text entries

    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...
  12. P

    How To Fire Macro after -----

    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...
  13. M

    Retain Pivot Table Formatting

    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...
  14. S

    Filtering Pivottables to show data that is equal of before target date

    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...
  15. S

    Making =GETPIVOTDATA Dynamic with an SQL Analysis Cube

    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...
  16. S

    Updating existing PivotTables from external data (Ms Access)

    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...
  17. A

    Pivot Table not opening data into a table question

    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...
  18. M

    Subtract one pivot column from another, within the pivot table

    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...
  19. A

    Help with using pivot tables

    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...
  20. S

    VBA Code for disabling multiple selection option in slicer - Excel

    Hi I am using slicer to show my pivot table data. However, I want to restrict the number of items selected in a particular slicer to 1 at a time. Can someone help me out. Data detail: Raw data looks like: Location>>People>>Designation>>Score Slicer is on location and I want to restrict the...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top