Use of Cyclic Group in Set Expression

[mmainiero]

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

[sunny_talwar]

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

[mmainiero]

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

[sunny_talwar · Accepted solution]

May be (just may be) you need this:

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

[mmainiero]

Looks good - I have to try it.

[#6]

Nice trick....