Dear All,
I have a requirement like displaying a subtotal and grand total based on field choosen.
Now i am able to display total for each line or end of all lines in model or grand total but unable to get subtotal at end of item.
current output:
line item 10
sut total - 50
line item 10
sut total - 50
line item -20
sub total -100
line item -20
sub total -100
expected output
line item 10
sut total - 100
line item -20
sub total -200
grand total - 300
i have tried with group by and calculation we are not able to use both options at a time.
Regards,
Raju