pivot table

  1. S

    Pivot table. Hide blank and show top 10.

    Whenever I try to do this it ends up deleting one or another filter. It is very not surprising to me as it filters same columns, But it also happens when I try to filter value over say 300, which seem to be different columns. Is there a way to hide blanks and show top 10 or alternatively hide...
  2. K

    Top 3 Values by Month

    Hello, I am working on a project where I need to identify our top 3 clients per month for volume and revenue. Right now I have the data displayed in a pivot table but I am not having any luck applying the "Top N" filters -- and the ideal solution is not to create a separate table for each...
  3. C

    Combining Multiple Tables in a Single Pivot Table

    I have a table for each month of the year on separate tabs each one named (both table and sheet) corresponding to the respective month The tables need to be on separate sheets for usability reasons. I want to create a pivot table which takes all 12 tables as input on one single sheet and allow...
  4. M

    Update Source Data for Pivot Table

    Hi all! I have a workbook that contains a pivot table, a data set, and several user input pages. I have a macro that updates this data set, and the size of the set may change between each update based on user inputs elsewhere in the workbook. I would like the Pivot Table to update as well...
  5. S

    Slicer list is to long to search

    Hi, I have a system generated list of all our receivings. I'm looking for a quick way to look up a specific invoice number. But to scroll through the list of 100's of invoice numbers takes to long. I have tried adding a second pivot table and using the trick of the pull down filter. But it...
  6. S

    Refresh pivot table external data with encrypted password

    I have 10 excel files that contain a table with many columns and many rows and that need to be updated frequently with new data. In order to have a faster record of some data from these files, I created a separate excel file that centralizes them all 10 files by external pivot table data and...
  7. B

    Combine Slicers in Pivot Table

    Hello, I have a fairly simple data table that I've easily turned into a Pivot table, but when going to add the only slicer I need, I'm not able to get all data into one slicer. My example is below. There are other columns such as dollars, etc, that I have not included in the example. What I...
  8. E

    Countif with Index on a Pivot Table

    Pulling off Pivot Table example: <colgroup><col><col span="2"></colgroup><tbody> </tbody> <tbody> Part Number Company 1 Company2 part 1 60 61 part 2 50 52 part 3 40 60 </tbody> Looking to do a countif on the entire row based on the part number with greater than or equal to 50. So...
  9. T

    Pivot Table Filtering and grouping

    I have a pivot table with 2 columns. Column A is "genre" and Column B is "count". All together there are 211 films counted across all 10 genres. 4 of the individual genres have a count of less than 10 as a result and I need to lump those results into a new genre called "other". The result...
  10. M

    Pivot Table Time Values Display As 00:00:00

    I'm working on a Frequency Distribution for time values. I have separate incidents with a start date and resolved date. I used an excel formula to retrieve the time difference between the two. I'm trying to make a pivot table with Time Elapsed but it shows up as 00:00:00. Any ideas of what's...
  11. V

    How to use a Pivot Table to sum the last 12 columns

    Hi Everyone, hope you can help....as usual. I have a pivot table based on an enormous database which essentially summarises each month points by individual. I need to keep all historical columns in the pivot (this is going back to 2012) but would like the pivot to calculate automatically the...
  12. M

    Unique by month management fee in a pivot table

    Hello everyone, I'm struggling with a problem on a pivot table. I have some data that looks like this <tbody> Date Month Management fee Client Billing amount 01/01/19 January 200 Client 1 500 01/01/19 January 250 Client 2 250 01/02/19 January 200 Client 1 560 01/02/19 January 250...
  13. T

    Pivot Table Calculated Field subtotals

    I am working on a pivot table based on data that has a region, a sub-region, dates, and then the available work potential in each sub-region by date. I need to do two things, 1. I need to create a calculated field based on the available work potential 2. I need to change the subtotals to...
  14. M

    Pivot Table Not Returning Sum, Only Returns "0"

    I am trying to simplify a horrible and old spreadsheet for attendance tracking (there is a worksheet for every employee, SMH). I am moving everything to a new spreadsheet to just be on one sheet with all of the data, and a pivot table to display the count of types of occurrences, and another...
  15. Q

    Custom Filter Groups for Pivot Charts

    I have a dataset with about 25 columns that I would like to visualize in a chart. Because of the large number of columns, having them all show up at once would make the chart too cluttered. Is there a way to create a custom filter for the chart to show predefined columns? For example, "show...
  16. T

    Excel Table Exceeds Rows - Options for Pivot Tables

    I need to create one pivot table for a report. My data currently exceeds the rows for excel, so I took the data and put it on different tabs. The headers are the exact same, but instead of one tab with ~1M+ rows, I have two tabs with ~500K. How can I connect these two tables to one pivot...
  17. Y

    VBA to intersect cell changes (both data validation) and action separate functions

    Hi Everyone, on my worksheet I have two cells B3 and C3 which have data validation. So what I want to do is when either of the cells change, it will update two pivot table's filters. (Target & Actual) Below is what I got working when looking at only B3 and updating the Region. The values...
  18. K

    VBA Excel to Find last column with data in Pivot Table excluding grand total column and row

    Hello, i have to find the last column with data(Column:AE in this case) in a Pivot Table excluding grand total column and row. I have tried different ways but all of it gave the column of the last cell( Column:AM) in Pivot Table. I have attached an image of the situation. Kindly help, Thank...
  19. D

    Pivot Table Deliverable Count by Date

    I have a table that I track deliverable in. In the table each deliverable is a column and I record the date it was received for each project. I was trying to create a pivot table where the rows were year/month, columns were the deliverable's and the body showed the count for each deliverable for...
  20. gmooney

    Pivot Table Data - File with data saved in Pivot Table but I don't have source data

    I have a file that has a pivot table with the data saved into the file. I want to be able to modify some of the data and then refresh the connection based on this new data, but I do not have the original data source file. I would basically like to replicate the original data source with the data...

Some videos you may like

This Week's Hot Topics

Top