Get pivot expanded dimension field name

[#1]

Hi,

Suppose I have 3 dimensions in a pivot table - A, B, and C - and collapsed as default.

When I click the first '+' sign to expand dimension B, how do I display the dimension field name 'B' in a text box?

Same thing to when I click the second '+' sign to expand dimension C, I want to display 'C' in the text box.

Thanks!

[#2]

Not sure I understand

You can have multiple values for B and C - is it just the first one that you want in a text box< all of them?

can you send and example of the oivot and what you would like to see in text box

[#3]

Hi Adam,

I am looking for field name not values.