Hello Nicky, thank you for your question.
To achieve what you want, you will need to group the data.
Mark lines 1 and 2 and group them by changing the Group by value to:
substring-before(@Name, ’ -')
Since lines 3 and 4 should be grouped differently, group that data using the following Group by expression:
concat(
substring-before(@Name, ’ - Google’),
’ - Commitment - ',
substring-after(substring-after(@Name, ’ - Commitment - '), ’ - '))
Please check and let me know if this works correctly for you.
I’m also sending you a video that explains how grouping and sum definition works, in case you get an unexpected result.
Let me know if you managed to solve the issue.