Drill Down Pivot Table Data From Button

kkleimola

New Member
Joined
May 15, 2009
Messages
4
I am looking to add a button to a worksheet which, on clicking, will display the data details from a referenced pivot table.

I know that you can display this data when double clicking on the desired total in the pivot table itself, but I have to face reality and deal with many computer illiterate folks.....

So, Instead of this:

Code:
Sub Macro6()
'
' Macro6 Macro
' '
'
    Range("I77").Select
    Selection.ShowDetail = True
End Sub
I want it to give grand total on click of the data displayed in the pivot table...regardless of which pivot field is narrowed down or narrowed out.
make sense?

Your help is greatly appreciated.
I can provide additional details/data if necessary.
 

Forum statistics

Threads
1,085,040
Messages
5,381,331
Members
401,734
Latest member
cvickers81

Some videos you may like

This Week's Hot Topics

Top