Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=min({<Week=>}aggr(sum({<Flag={1},Week=>} Sales),Week))
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.
It is working. Thank you...