Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
May be like:
Straight table:
Dimension: [Buyer Name]
Expression: =Sum({<[Period Number]={"$(=Max([Period Number]))"}>} [Units YTD])
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
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?
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.
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