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

    Sum Latest Entries

      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



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

      Example of Records: