Parent of item in Pivot table

J

Jens Meier

Hello NG,

i got an Excel 07 pivot table with the dimensions Region, Country, City
I now want to get the "parents" of a double-clicked item. Example

Europe
UK
London

If a users double-klicks on "London" i need to somehow get the "UK" and
"Europe" value via VBA.
I catched the OnDoubleClick event of the worksheet and set cancel=true to
avoid drilling down that normally would occur when double-clicking an item
in a pivot, which works fine. I tried to adress the "parents" via
ParentItem, but id did not succeed. Can anyone help?

Regards,

Jens
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table: configuring calculated field correctly 4
Percentage of parent row in Pivot Table 1
zeros generated by a calculated item in pivot table 3
ImportXML doesn't give me a table 4
OT| The Decline and Fall of the American Empire: Four Scenarios for the End of the American Century 0
FWT Newsletter - Weekly - February 2, 2004 1
FWT Newsletter - Weekly - October 4, 2004 2
WTD: Nvidia Videocard for 4x AGP Slot 0

Top