Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am trying to create a dynamic column inside a straight table showing the ranking and using the linear gauge representation. I use the Group1 cycle-group to enable users to select different dimensions and monitor several measures.
I think this max(aggr(sum(Sale), getcurrentfield(Group1))) does not work because the aggr function works only with explicit dimensions (Customer, Country, SKU, etc.). Although, if you ask me, the cycle-group is not a calculated dimension.
Thanks for advices
If the group contains dimensions that are created as fields in the script it should be possible. If the group contains calculated dimensions it won't work. If the field name contains spaces you may need something like max(aggr(sum(Sale), $(='[' & getcurrentfield(Group1) & ']')))
If the group contains dimensions that are created as fields in the script it should be possible. If the group contains calculated dimensions it won't work. If the field name contains spaces you may need something like max(aggr(sum(Sale), $(='[' & getcurrentfield(Group1) & ']')))
It works. Perfect
Thank you Gysbert.