Is there another way to get a Used Field from the dimension cycle group and use it in the Aggr function?

[nenadvukovic]

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

[Gysbert_Wassenaar · Accepted solution]

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) & ']')))

[nenadvukovic]

It works. Perfect

Thank you Gysbert.