drill down

  1. A

    VBA Show detail pivot table row

    Hi I am trying to show the detail on each of these rows (except the blank and grand total row) & rename the sheet to the row label without double clicking each row as the tables can have hundreds of rows. I have tried the coding below but it returns the details of column 2023/001, I would...
  2. H

    Drill through - Behaviour in PowerPivot/Pivot Table

    Dear All, I regularly use Power Pivot and Pivot tables for various analysis and drill through the figures to see what combination of transactions makes those figures. In my raw data there are 44 columns. Every time I drill through, I get an exploded view of that table showing raw data - all 44...
  3. J

    Pivot: Double click value in a single cell showing all data

    Currently I am using Microsoft Office 365 at work, version 2102 (Build 12801.21278) Steps: Execute query> copy results and paste into new workbook>Insert Pivot table on all data>add columns and rows When using a Pivot table in 365, if I attempt to double click a cell to show the records behind...
  4. P

    Drilling down in a calculated item in a pivot table

    Is it possible to drill down on calculated items in a pivot table? On non-calculated items, I can drill down just fine--by double-clicking the item, it creates a new sheet with full details. However, when I double click on a calculated item, Excel just displays the formula that comprises that...
  5. S

    Drill down in created measure, how to?

    Hi there I want to use a measure to count the number of times certain words appear in a column and based on that, be able to drill down and look at those records in a new sheet when double clicking on the value. I am able to create explicit measures in the data model, but am not able to drill...
  6. 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...
  7. 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...
  8. 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...
  9. 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 :)
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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

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
Back
Top