A sub-report at least is necessary to get the sum of an aggregate function. So, I don't see any other way to do the sum of aggregate without sub-report or join. 

Hi John_paul_raja,

In the report definition, we have fx button next to column source. Below is the screen print

Click on the fx utton to launch  calculation builder. Press down arrow to load the different functions which satisfies your requirement.

If you are looking something different or my understanding is not correction then I would request you to elaborate the requirement

Please feel free to reply your thoughts

Thank you

Hello,

There is no direct way to achieve your requirement.

You need to create sub-reports.

Thanks,
Gisela