I'd like find a way to extract the Row & Column Filters applied to the selected value in my pivot table. The exact data I need is the exact data that appears in the screen tip when you hover over a value in the table. For example, the screen tip shows the following:
Sum of Rec Qty
Value: 30000
Row: 5/21/2014 - Fixed - Firm
Column: West

How can I return the Row & Column info of the selected cell in VBA? If someone could show me that code, I could adjust it to fit my end goal which will be passing that data to another function when someone double clicks on the pivot value. Basically, I'm going to attempt to hyjack the current pivot drill through with my own custom drill through, but I need to pull in the filtering metadata.

Thanks for your time and help.