Aggregate excluded values

[Anonymous]

Hello,

I am trying to sum sales for the time period that is not selected. I would like to sum the sales by week and display in a table with SKU number and the sum of sales. However, I am not getting a null output.

Any help would be greatly appreciated.

sum(

aggr(

sum({$<Week=E([Year Week]), SKU=P(SKU) >}Sales)

,  SKU, Week)),

)

[sunny_talwar · Accepted solution]

Try this:

=Sum({$<Week=E([Year Week]), SKU=P(SKU) >} Aggr(Sum({$<Week=E([Year Week]), SKU=P(SKU) >}Sales), SKU, Week))

[Anonymous]

That works! Thanks!

And if I wanted to take the standard deviation of the sales for each of the weeks, how would I go about writing the syntax?

Thanks!

[sunny_talwar]

May be this:

=Stdev({$<Week=E([Year Week]), SKU=P(SKU) >} Aggr(Sum({$<Week=E([Year Week]), SKU=P(SKU) >}Sales), SKU, Week))