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
Hi, what do you mean by header? The label? This is done in the expression tab in the properties of the pivot table
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
I think you are talking about the label in the expression tab....
m i right?
The label in the expression tab
Ok, as we say, go to the expression tab or dimension tab and you have a Label text box
Retrieving data ...