Calculated subtable

Hi   I need to analyse some data and get a specific output I am struggeling with:   Raw Data     Company Revenue Owner Client A 1000 Geoff Client B 1500 Bob Client C 2000 ...