Aggr

[Anonymous]

Hello,

I want to sum([Units YTD]) for the max([Period_Number]) and aggr by Buyer Name. How exactly can I do this?

Thanks,

Isabel

[tresesco]

May be like:

Straight table:

Dimension: [Buyer Name]

Expression: =Sum({<[Period Number]={"$(=Max([Period Number]))"}>} [Units YTD])

[Anonymous]

Hello,

Thank you, that works as a straight table however I should have mentioned that I am trying to do it as a text object.

Thanks,

Isabel

[tresesco]

Are you expecting a single value as output? If so, then what do you really mean by '... and aggr by Buyer Name' ? Could you explain a bit more?

[simondachstr · Accepted solution]

Based on tresesco's post try the following:

=aggr([Buyer Name], sum({<[Period_Number])={"$(=Max([Period Number]))"}>} [Units YTD]))

Note, however, if you have multiple Buyer Names you might need to aggregate your result.

[Anonymous]

Hello,

Yes, I do have multiple buyer names and would like the result based on the Buyer Name selected in a list box.

Thanks,

Isabel