Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Hi Jeroen
this is great 🙂 Thanks a lot!
Best,
Oliver