Pivot table. How to access the values in the header

[#1]

Does anyone know how to access the values in the header of a pivot table.

Ive tried rowno() and column(1) and columnNo() but have had no luk hear

Thanks

Martin

[jvitantonio]

Hi, what do you mean by header? The label? This is done in the expression tab in the properties of the pivot table

[#3]

Hi, thanks

This is the label in the expression tab. I was trying to access the value in a "Add Calculated Dimension" in the Deimension tab, thanks

MArrtin

[#4]

I think you are talking about the label in the expression tab....

m i right?

[#5]

Thats right

The label in the expression tab

Thanks

[jvitantonio]

Ok, as we say, go to the expression tab or dimension tab and you have a Label text box