sum aggr max per respondent over changing dimensions
What I am trying to do is find max values for 'BereikBruto' over several dimensions, however: per individual Respondent, where Respondents are unique in the lowest dimension of a Commercial, but have a multiple presence over a Date, Channel etc. wiht several values for 'BereiksBruto'.
I am looking for the highest value per Respondent over several dimensions and add these up.
Adding simply all 'BereikBruto' (meaning gross reach) values up is displayed in sum(BereikBruto). What I need to esthablish is a figure around 13mio in total for 'net reach' in total.
As shown below, the green value is correct (right column) but I can not get the formula correct to find my solution. Please advice.