How can I calculate the sum of max values in aggregated data. In my example, I enter data for all organizational units on a monthly basis. As this is data collected on the same participants, I wanted to calculate the max for each organizational unit (i.e. take the month in which several people were affected by the activity), and then add up all the max values for the different organizational units.
In my screenshot, I’d like the total to be the max.
Any ideas?