Hi,
In a one to many situation, i wanted to pull a data set that will give me the last 3 results but present in 3 columns rather than 3 rows.
So my example would be...
Reference Note1 Note2 Note3
XXX Text Text Text
Now I know I could have a formula rather than the field but I don't know what the formula would look like to pick 1st then 2nd then 3rd note.
In a one to many situation, i wanted to pull a data set that will give me the last 3 results but present in 3 columns rather than 3 rows.
So my example would be...
Reference Note1 Note2 Note3
XXX Text Text Text
Now I know I could have a formula rather than the field but I don't know what the formula would look like to pick 1st then 2nd then 3rd note.