drill down

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

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

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

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

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

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

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

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 :)

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

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

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

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

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

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

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

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

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

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

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

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