3 Replies Latest reply: Jul 20, 2015 2:17 PM by Sunny Talwar RSS

    Aggregate excluded values

    Isabel Nowinowski

      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)),

      )