AnsweredAssumed Answered

Ad-hoc report: Limit result-set by returning only the rows within a group with the latest update date

Question asked by mzmrizu on Apr 15, 2016
Latest reply on Apr 18, 2016 by Nika_Hadzhikidi

Ad-hoc report: Limit result-set by returning only the rows within a group with the latest update date.  I have access to ad-hoc reporting and am very familiar with SQL/Sub queries etc, however I cannot within PPM figure out how to achieve the following through ad-hoc reporting:

CURRENT RESULTS

Location              Status    Last Updated Date

Tuscon                 Active    3/9/2016

Tuscon                 Closed   4/12/2016

Tuscon                 Est          2/20/2016

Xavier                   Active    9/5/2015

Xavier                   Pend      12/1/2015

NEEDED RESULTS (only return the latest updated date result)

Location              Status    Last Updated Date

Tuscon                 Closed   4/12/2016

Xavier                   Pend      12/1/2015

 

Does this require a combination of calculated fields and filters?  I know how to build a sub-query outside of PPM but need to accomplish this within PPM ad-hoc reporting (I am not an admin for the system, so my access is limited to this).

Outcomes