drilldown

  1. L

    Pivot Table Drilldown - different deleted columns, formatting depending on pivot table clicked.

    Hi, this question is an expansion on a previous question which had an answer to drilldown a pivot table to hide or delete particular columns and apply formatting...
  2. 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...
  3. M

    Source Data Display

    Hi, I am wondering if anyone here knows if there is any way possible to recreate the 'Double Click to Source Data' event on a pivot table. For instance, I have created a few tables using sumif and countif etc etc, I would like to recreate the 'Double Click to Source Data' event within this...
  4. N

    PowerPivot Chart - Link 2 charts' X axis

    I want to link 2 PowerPivot Chats' X-axis. For example, Chart 1 and Chart 2 has different sales figure for northern and southern region. The X-axis has time period as hierarchy (Year, Quarter, Month). Now when I drilldown to Quarter from Year in Chart1, I want the same to automatically happen in...

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