8 Replies Latest reply: Jul 17, 2013 10:09 AM by David Radczyc RSS

    Sum sales after specific date

      Hello,

       

      I want to calculate Sales after specific date. I have existing calendar (CalendarDate), but I want to use date range from Excel file.

       

      New data will be uploaded every week. This is Spreadsheet with specific dates (connected by Customer filed):

       

      CustomerDate
      Customer101/05/2013
      Customer201/06/2013
      Customer306/07/2013

       

      I would like to calculate Sales after those dates and see this in Straight table. Is there anyway to do this in expression?

      The problem is when I put =sum(Sales) will shows me the whole sales as normal, but I tried something like:

      sum({<Date = {"$(>=(Date))"}>}Sales)

       

      It doesn't work. Any ideas please?

       

      Thanks,