Ranking in a dynamic group

[#1]

Hi all

I use a dynamic group as a dimension to show our customer performance.

To show the customer performance related to others I use small diagrams in the table.

To calibrate those diagrams (Rang)  I use this formula

max(total aggr(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR), BP.Name))

but instead of "BP.Name", that is the lowest level within my dynamic group, I would like to have the current selection within the dynamic group.

The name of my dynamic group is BP.Group

How can I do this?

[jjordaan · Accepted solution]

Hi Oliver,

You can use the name of the cyclic within dollar sign expansion.

Like this

max(total aggr(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR), [$(=GetCurrentField([Cyclic Group Name]))]))

Hope this helps

[#3]

Hi Jeroen

this is great 🙂 Thanks a lot!

Best,

Oliver