Need date of first occurance

Discussion created by stevem on Jun 17, 2016
Latest reply on Jun 23, 2016 by Mike_Mitchell

I keep track of music chart data.  I have input data since 1/1/2016.  I have now created a summery report that sorts the data by song title.  In the sub-sumery part of the layout, I have the song title, singer, and the peak chart position of the song (using a summery field).  For this example, I have the chart history of "Country Nation" by Brad Paisley.  I can clearly see in the sub-summery line the song reached #18.  I want to put in the sub summery line the date that the song first reached #18.  I can go down the chart history and see it reached #18 on 2/13/2016, but I want that date to appear in the highlighted sub-summery line beside the peak position.  How do I do that?