Show last item of grouped data

Hi guys,

Data: we have the data type “Targetletter” which shows the name of the person, his target and the office place.

I would like to show the last item target per person in a chart, filtered on the same office place.

I have already managed to create the chart, but I am unable to show last item target of the filtered group per person. Can you guys help me?

Targetletter-Artiflex-Bubble-Editor (1)