Group Help

[VishalWaghole]

Hi Community

I have one pivot table containg Dimension as one Cyclic Group.

Cyclic Group having 3 Fields.

My requirment is, The field which i select such fields get store into one variable.

I tried it by GetCurrentField() function by passing Group Name but it didnt work.

So Please Help me......

Thanks

[Gysbert_Wassenaar]

Your requirement is not clear to me.

If you want to store the name of the current field in the cycle group in a variable you can use the getcurrentfield function. For example a variable vField: =getcurrentfield(MyGroupNameHere).

If you want to store a list of dimension values of the current field in the cycle group in a variable you can try this:

vField:  =getcurrentfield(MyGroupNameHere)

vFieldValues: =concat(distinct $(vField) ,',')

or vFieldValues: =concat(distinct $(=getcurrentfield(MyGroupNameHere)) ,',')

[VishalWaghole]

Hi gysbert thanks for ur rpl...

I have one cyclic group which contain three dimensions

Number1

Nymber2

And

Number3

If i select Number1 then variable store the field as number1 but not the field values.

Similar to Number2 and Number3

How can i achive this task..??

Thansk..

[VishalWaghole]

I tried it by using

=getcurrentfield(MyGroupNameHere)

this but it wont work..

PFA here

[Gysbert_Wassenaar]

See attached qvw