Calculated Dimension: How to retrieve the most recent date
I am trying to create a pivot table that includes a "Completed On" date column.
In my data set, i have many "Completed On" dates to one "SID" (Unique identifier).
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?