drill down

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

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

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

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.

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