In this case I suggest you use an Working with Aggregated Data Sources
This will allow you to create a new datasource in your VA report with the aggregated data. Please note that the data element "max of pct" from the previous example will not be available in the aggregated data source, but can easily be derived using
Max [_ForAll_] ('engine / cylinders'n)
If needed the new aggregated data source can be joined back to the original data.
... View more