5 Replies Latest reply: Jun 13, 2017 11:26 AM by Robson Silva

# Use of Cyclic Group in Set Expression

Hi community,

I would like to use A Cyclic Group (name:Group) das an Dimension and reuse this Selection in a Set Expression.

Like:

Sum(counter) / sum( Total <Group> counter) this is actually working!

But i exprected something like that.

Sum(counter) / sum( Total {<GetSelectet(xxxx)}>} counter)

Can anybody explain what is the correkt syntax and how to use it?

Thank you  all

Markus

• ###### Re: Use of Cyclic Group in Set Expression

Set expression or total qualifier? I am confused as to what you are looking for?

• ###### Re: Use of Cyclic Group in Set Expression

Hi,

I'm not sure what is here de different.

I will have the selection choosen in the cyclic group transfered or used into the formula.

Or the other way round - how can I use a formula dependent on the selected dimension.

Maybe these are two different things..

Regards,

Markus

• ###### Re: Use of Cyclic Group in Set Expression

May be (just may be) you need this:

Sum(counter)/Sum(Total <\$(='[' & GetCurrentField([GroupName]) & ']'))> counter)

• ###### Re: Use of Cyclic Group in Set Expression

Looks good - I have to try it.

• ###### Re: Use of Cyclic Group in Set Expression

Nice trick....