Drill Down Pivot Table Data From Button

[kkleimola]

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:

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.