Pivot Table drill downs

Pivot Table drill downs

Post by TWFya0ZyYW » Sat, 06 Aug 2005 01:10:04


Hi all,

Does anyone have an example of a piece of VBA code which would allow for
drilling to the leaf level of a dimension than hiding the parent levels on
the row axis?

Thanks in advance.

Mark
 
 
 

1. Pivot Table Drill Down

2. Pivot Table - Drill down to source and update

Is there a way to drill down on a cell of a pivot table and update or change
the underlying source data from the pivot report? I'm afraid that the users
will have too much trouble understanding the data in a matrix or table format.

The Pivot Table report is being used as a budget report and I would need the
user to be able to change or adjust some of the fields in the amount area.

The drill down displays the source rows in a new worksheet - that doesn't
solve the problem at all.

This one file will be access by several users separately to view their
specific budget, make changes, save the file and get out for the next user to
do the same.

Any ideas from the you brilliant wizards would save my job!

3. Pivot table drill down data

4. how to see complete memo field in pivot table drill down detail

5. Pivot table drill down formatting

6. Pivot Table drill down and 256 character limit

7. Pivot table "drill down to data"

8. Pivot Table Drill down - what does it sort on

9. Pivot Table - Drill down colors hard to read

10. Pivot Table Drill Down Number Formatting

11. Pivot Table Drill-down click opens another Excel Doc

12. Macro to Format the Pivot Table drill down

13. Pivot Table Drill Down

14. Pivot Table Drill Down Formatting

15. Pivot Tables - Drill Down