Pivot Table: How to get the name of the dimension placed in first dimension

[Thathayoyo]

Hello,

I have a pivot table where i want to know the name of the first dimension ( Item Desc in the exemple below) so that i can store it in a variable. For exemple if the first dimension is Item Desc then my variable need to return Item Desc. If the user is moving Product Group as the first dimension then the variable need to return now Product Group.

Thanks.

[NoahF]

You put this:

=if( $(vToggle) = 1, [Item Desc] , 
	if( $(vToggle) = 2, [Product Group], [Customer]))

 as your Dimension. As your field. Instead of [Item Desc] for example. Put the whole expression, and then with your toggle it will change, based on the selection. This should always stay your first dimension then. The user should not switch them manually but use the variable input object instead, to switch the first dimension. 
It's a workaround.

[Thathayoyo]

Thanks