Hi there,
i have the following problem:
Example of my detail section (which is grouped by item number). The item is stored in different units and units contain different Batch numbers. Goal is to see the smallest /oldest Batch# and the correct unit to it.
Unit: Batch#
1000004840 2022256
1000004837 2022257
1000004837 2022180
1000004839 2022203
1000004839 2022256
_______________________
The smallest batch# here is 20222180 (i pulled the smallest value in the group section). But how am I able to get the correct unit to the smallest batch# - which should be 1000004837.
If I just put the field on the group footer it doesnt show the right unit (of course) but I am lost on how to set this up.
Any Ideas ?
Thank you
Jacqueline