Calculated Dimension

[#1]

Hello,

I have a MaxString expression with set analysis as an expression. I was wondering what I would have to do to make this a calculated demension. Here generally what the expression looks like.

MaxString({$<SalesYear={"2013"}>} SalesOpStatus)

Any help would be greatly appreciated.

Thanks!

Jeff

[swuehl · Accepted solution]

You probably want the MaxString grouped by one or more dimensions? Then you need advanced aggregation:

=aggr( MaxString({$<SalesYear={"2013"}>} SalesOpStatus), DIMENSION)