Calculating the sum of max values in aggregated data

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?

1 Like

Hi @johnntab

Welcome to the DHIS2 Community!

For this issue, you can use an indicator and the aggregation type ‘MAX’. This will give you the MAX value for each OU.