In the attached file I have some data and a Pivot table.
In the data source column #3 (Sub Project Number) is a value that I do not show, but a value I need.
When selecting a subproject in the Pivot, how do I get the value of the Sub Project NUmber child item using Excel VBA.
Please notice that the column "Sub Project" is not Unique. (10 - XXXXX)