I added tags to this post to increase visibility.
Hello. Please see appended example template. It contains a table, which is filtered on a specific compound and sorted by peak_area. I'm using the last() and previous() function to write a value in two additional columns. These two columns contain the smallest and 2nd smallest value of in the peak_area. These are then saved in variables you can use for further calculation.
If the order of the sorting is reversed you will get the largest and the 2nd largest value.
To get this into your report, just group all report items and save the composite group. Then open your template and drag the group into the template. You then modify it as needed (and hide the table so that it's not shown in the report).
Hope this is what you were looking for.
smallestAnd2ndSmallest.rdl.zip 20.5 KB