ganeshsamant
New Member
- Joined
- Nov 23, 2020
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
I have 15 Row-field (Only Row-field, No column fields) & QTY as data-field in my pivot table.
Suggest me VBA code to get all pivot items of previous Row-field for a particular pivot item in last Row-field.
For example in below pic for pivot item "TE-118" from row-field "TAG NO", I want to extract preceding filtered row-fields.
As in below Pic I want to extract " 1.5" 150# XS-WNRF B16.36-ASTM A105 etc....upto...-12.755-158" For pivot Item TE-118 of "TAG NO" rowfield.
Now excel shows these details in Pop-Up when mouse over is on particular item as shown in below pic, I just want to know how we can extract these details through VBA Code. Thanks in advance.
Suggest me VBA code to get all pivot items of previous Row-field for a particular pivot item in last Row-field.
For example in below pic for pivot item "TE-118" from row-field "TAG NO", I want to extract preceding filtered row-fields.
As in below Pic I want to extract " 1.5" 150# XS-WNRF B16.36-ASTM A105 etc....upto...-12.755-158" For pivot Item TE-118 of "TAG NO" rowfield.
Now excel shows these details in Pop-Up when mouse over is on particular item as shown in below pic, I just want to know how we can extract these details through VBA Code. Thanks in advance.
