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

    Aggregate excluded values



      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({$<Week=E([Year Week]), SKU=P(SKU) >}Sales)

      ,  SKU, Week)),