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.
use recNo() while loading data
then use max(recNo) to get total no of rows in table
add 1 as flag in load script
and use sum(flag) to get total no of rows.
Retrieving data ...