Aggr Function - How to return expression results to each row

[#1]

Hello,

I'm struggling with the best way to say it but basically I need to aggregate on a single dimension but need to return the results on each row of a straight table which has more dimensions. I have included an example which makes it more clear.

The easiest thing to do would be to use the AGGR function in the dimension, but I can't do this as I need to set the field as a "Link" which can only be done as an expression.

Any help or guidance would be MUCH appreciated. Thanks!

[stigchel · Accepted solution]

I think you can use the total qualifier like this

=date(aggr(max(TOTAL <[Org Name]> Date),[Org Name],Role,Type))

[#3]

Piet Hein van der Stigchel - Perfect! I knew there was an easy solution to this. Thank you very much.