4 Replies Latest reply: Oct 28, 2014 2:06 AM by jagan mohan rao appala RSS

    Calculated Dimension: How to retrieve the most recent date

      Hi,

       

      I am trying to create a pivot table that includes a "Completed On" date column.

       

      data1.PNG.png

       

      In my data set, i have many "Completed On" dates to one "SID" (Unique identifier).

      data2.PNG.png

      How do i create a calculated dimension that gets the most recent date from the "Completed On" column? Currently, SID 114381 is retrieving 14/10/2014, but i want it to retrieve 17/10/2014. How is this possible?

       

      Thanks,

       

      Matt