drill down

  1. K

    VBA Protected Book with PivotTables -- Allow "Show Detail" feature and delete sheets

    Hello, I have a project requiring the use of PivotTables in a protected Workbook. I need to code a macro that will allow users to drill down into the PivotTable values, and then will automatically delete them once the book has been closed. I have found plenty of threads demonstrating how to do...
  2. S

    Pivot Table with drill down data

    So I have a boat load of data that a client asked to make drill down. Here is what it is supposed to look like when the data is rolled up into their respective category: https://imgur.com/a/AokVF The top 5 rows are the categories. Their totals represent the sums of all the records associated...
  3. J

    PowerPivot - Show details/drill down filter limt

    Hello, does anyone know if there is any limits on the amount of filters that you can apply to a Pivot table in PowerPivot? I have a pivot table that show details/drill down stop working when I apply one of the filters (a multiple selection filter), but when I reset this filter (select all...
  4. A

    Drill down Rows

    Hello there, please, I ask for some support at Power BI, I'm new at that fabulous application. I got data from a XML file >> then edit >> as shown I ask for how can I drill or split each line in an autonomy row then fill down the other rows, is that applicable in Power BI, I hope that, please :)
  5. F

    Pivot chart drill down

    Hi, I have a problem with the drill down on a pivot chart. Normally I would expect that it shows the underlying data that leads to the number I can see in the pivot chart. But when I do the drill down it just shows me the number of rows of the biggest amount in the pivot chart row. Is there a...
  6. S

    Excel Drill Down not working correctly - double click produces all data view

    Hello...I'm working in Excel 2007 and I'm using a data connection to SQL 2008. I've created a few pivot tables using the same datasource/connection string. My users want to be able to drill down in the pivot table to see the detailed data behind. All but 1 of my pivot tables seem to be...
  7. J

    Summary Report Click to Drill Down

    I have a report that uses two workbooks: 1. Back End - Contains data and pivots 2. Front End - Summary that displays pivot values through 'Index/Match' lookups. Is it possible to somehow click on a value on the Front End displayed value and pull up the drill down details (like double...
  8. B

    Missing data when using drill down in Pivot Table

    I am a new user to Excel 2013 recently upgrading from 2003. I am using a Table which is linked to an external data source (SharePoint List). In the Sharepoint List there is a column which collects text data "Notes/Comment". The external data link works well and all the data from the...
  9. L

    Drill Through not working / Drill thru not working

    I have a PowerPivot report and when I click to view the detail, a new tab is created but I get a message that says "Retrieving data from [Name of my Measure], [a list of all filters in the report], (First 15000 rows...)" and nothing is populated, not matter how long I let it think. This same...
  10. P

    multilevel drill down in excel 2013

    Hello guys, I am working on Excel 2013, I have sample table data that shows populations based on cities, the columns in the table are continent,country,city, population. what i want is : initially show continents and populations(sum by countries in the continent)), when i drill down by...
  11. P

    multilevel drill down in excel 2013

    Hello guys, I am working on Excel 2013, I have sample table data that shows populations based on cities, the columns in the table are continent,country,city, population. what i want is : initially show continents and populations(sum by countries in the continent)), when i drill down by...
  12. T

    Excel 2007 Pivot Filter Dril Downl

    Hello all. Is there a way in 07 when you have muliple pivot filters as you select one, it limits selections on the other filters. In other words if I have a State & City filter on a pivot, is there a way to set it up where when I select the state it only shows cities that are in the state I...
  13. K

    Pivot table show details on a summary sheet

    I created a pivot table generated from a table that uses a source file but only takes the necessary data. I needed to sum how much a person has spent and if they go over a certain amount only then do i need to see the details so I can add to records. I didnt want to have to drill down on each...
  14. G

    Drilldown Pivot Table - details to appear on the same tab

    Hi, I have 2 pivot tables on the one tab, called "Other VAT". When I double-click a cell within the first pivot, instead of opening a new tab with the data, I want the data to appear on the same tab in cell A40, which is a free cell underneath both the pivot tables. If I then doubleclick a...
  15. E

    DrillDown functionality in message box

    Hi, I have pivot table containing 12 fields, if I double click on any cell in pivot table new excel sheet open and shows all 12 fields data in 1 row. I want to show message box displaying these 12 fields data on a button event. Is it possible ? Thanks in advance
  16. R

    Pivot chart, problem drilling through to underlying data.

    Using the code below I can click on a Pivot Charts column and drill down to the data, but the Pivot Chart needs to be a "Pivot Chart" sheet. I can't get it to work when I change the location of the "PivotChart" and embed it in an ordinary worksheet. Does anyone know how I could manage...
  17. A

    Auto format Pivot Table Drill Down

    Hi, I am trying to find a way to re-format the drill down results from pivot tables. The generic tables include all of the source data - at times I only want a selection of the column headings, or at the very least, be able to adjust column widths etc to make it more aesthetic. Any help would...
  18. C

    Pivot Drill Down - Updating Source Data

    Hi everyone. I'm looking for a solution to some data I'm working with in a pivot table. It's a monthly complaints log that has 9 columns and a varying number of rows (depending on number of complaints). I've a basic pivot that serves as a 'front end' that summarises the number of complaints...
  19. G

    Pivot Table Drill Down Excell 2003

    Howdy, How do I use the drill down function? I've seen it work by just double clicking the cell, however when I double click a cell in column B, it returns the same worksheet as when I double click the cell in column A or C etc.
  20. T

    Help Needed With Pivot Table Drill Down Data

    Ok so I have this large database that I need to create a pivot table so we can send it to the division leaders who can then click on their open, past due, or closed items in the pivot table to see the drill down items. The pivot table is setup with several columns identifiers going into the...

Some videos you may like

This Week's Hot Topics

Top