Help on aggr expression

[#1]

Hi,

I need to find the minimum sales aggregated by Weeks. This needs to be calculated irrespective of the selected week. But the selections on other dimensions can affect the min sales value.

How can we acheive it? Refer the attachment

[#2 · Accepted solution]

Try this:

=min({<Week=>}aggr(sum({<Flag={1},Week=>} Sales),Week))

[swuehl]

Try maybe

=min( {<Flag={1},Week=>} aggr(sum({<Flag={1},Week=>} Sales),Week))

edit: Marc was somewhat faster. Same idea, just need to clarify how to handle the Flag field.

[#4]

It is working. Thank you...