Grouped Column-Names in Formula

[#1]

Hello,

how can I access the grouped column name in a formula?

for example: in a pivot table

Thanks

[#2]

Is it a Grouped Dimension or Grouped Expression? If it's a Dimension, it is:

=GetCurrentField(GroupName)

I don't believe a Grouped Expression can be referenced that way.

[#3]

Hi,

that's Expression

[#4]

I don't believe there is a way to identify that selection. Expression groups don't have names and can't be referenced by GetCurrentField().

[johnw]

I've handled this in the past by making a fake expression group that's actually a cyclic dimension group. In the attached example, that lets me change the sort order based on which "expression" has been selected.

[#6]

Very nice - I would like to take this one step further by incorporating into a Scatter Chart which appears to work best with 2 dimensions and 2-3 expressions.  (3rd expression can be used to affect bubble size).

However I would like the 3rd expression to actually be a group of expressions allowing the user to choose how to size the bubble/data point (ex: Margin %, Deal Size, # of products).  And for the selected expression to be listed in the chart.  GetCurrentField(GroupName) seems to not apply here for the reasons mentioned above (grouped expressions do not have a name?)  Any ideas?  (I tried using John's method above which did not carry over well for the Scatter Chart)