Excluding a particular summary line from grand summary

[chirag]

Hi,
I want the grand-summary line(yellow in color) to exclude the value of (+blank) row.

Now: Total(grand-summary) = 33, 998.03 including 6156.06(blank)

Requirement: Total(grand-summary) = 33,998.03 - 6156.06 = 27,841.97

[paramvir]

you would need to use custom aggregate to exclude the blank row.

Rows information which would be required for the custom aggregate in your case is available since v6.

https://paramquery.com/pro/api#method-aggregate