Calculating total lines in P&L Reporting

[stanlyrj]

Hi Community,

Here I'm trying to calculate Total lines from a P&L table.

The below given is the structure of my P&L table.

I have tried using aggr() and sum().

Can anyone suggest me any expression to solve this issue?

Thanks in advance.

Regards,

Stan

[PrashantSangle]

use recNo() while loading data

then use max(recNo) to get total no of rows in table

or

add 1 as flag in load script

and use sum(flag) to get total no of rows.

Regards,