Get Hidden Value from Pivot Table

[BrianAll]

Hello,

I'd like to know if I can get through VBA the value of a hidden field in a Pivot Table.
Imagine to double click on the "value field" in the pivot table. This creates a new table where I can find the (hidden) field and the relate value that I will assign to a variable.
I actually can disable the screen update, create the table by double clicking on the value, take the detail value that I need, delete the new sheet.
I'd like to know if there is a property (Inner Detail?) that enables me to get the same value.

Thanks
Regards

[peterrc]

Hi Brian,

Add the hidden field to the Pivot Table and then hide the field (column) in the Pivot Table.
When you want the "hidden" value simply unhide the field (column), then re-hide.
Would this work for you?
(or you could add the unhide/hide event to the macro if need be)

Regards

peterrc

[BrianAll]

Hello
well, this is more or less equivalent to the workaround that came to my mind. I think it can work, yes.
But my question was about the chance to get the value through a VBA code that says "go there and take the value" (kind of a query) without adding/hiding fields on the sheet.

Thanks again

[peterrc]

Hi Brian,

Is the "value" you're after the total value of the hidden field?

Regards

peterrc

[BrianAll]

Hello,
no, it is not field in the value area of the Pivot Table.
Please, if you can, take a look at the attached file.
I've highlighted in yellow in sheet "PT_Detail" the field that I need to be "captured" by the VBA code.
The "PT_Detail" sheet is coming from the double click on the row total value (yellow = €1,00) in the Pivot Table ("PT" sheet).
I can actually use this procedure (or the one you suggested) using VBA code but I'd like to know if there is a VBA property that allows me to get/read that specific value without displaying and hiding columns/tables.

Thanks again