5 Replies Latest reply: Oct 15, 2014 9:39 AM by Gabriel Rocha RSS

    How to aggregate/consolidate date fields?

      I created a table that has the date fields below. Each date has data (numbers) in other columns associated with it.

       

      I want to consolidate the date fields and aggregate the data associated with the same month-year. The result should be only one instance of each date (one 'Dec-2005', one 'Jan-2006') with the correlated data summed up. How can I do that?

       

      Thank you,

      Naveed

      10-15-2014 8-23-39 AM.png