In the working ump server the nisapi_wasp portlet was 8.40 and in the non-working ump servers this was 8.10
Data used to populate the UMP USM Group Trend reports/Top N are done by the nisapi_wasp portlet.
Since the version was lower in the two secondary umps where this is not working needed to get this to the right version first
Deploying nisapi_wasp 8.40 on the two ump servers having lower version to match the one on the working ump resolved the issue
Deactivate wasp during the nisapi_wasp deployment and activate after deployment.