drill down

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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 :)
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  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. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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
  17. 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...
  18. 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...
  19. 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...
  20. 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.

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top