8 Replies Latest reply: Dec 2, 2013 9:09 AM by Bruce Tedder RSS

    Sum Latest Entries

    Bruce Tedder

      Hi All

       

      I have a table in my DB which stores Sales Forecasts.  For each Forecast (weekly) by Sales Rep, the will create a new Forecast Record and a value.

       

      How would I use the Sales Rep as the dimension, but sum only their latest Forecast?

       

      In the example below I need to return:

      Bruce     20

      Andy     4

       

      Thanks

      DateRepValue
      4 NovBruce10
      4 NovAndy5
      11 NovBruce15
      11 NovAndy7
      18 NovBruce20
      18 NovAndy4

      Example of Records: