Hello,
I have issue with table object, my tables are related as follows in attached file and the problem is:
When I have Name(CustomerName), SalesId(Or InvoiceId) and CustInvoiceTrans.LineAmount column "CustInvoiceTrans.LineAmount" is showing values correctly, but I need that value to be summed after grouping by name(CustomerName) - I just remove salesId(or InvoiceId) column from table and my table become empty instead of showing summed lineAmount by Name.
Any suggestions?
Thank You in advance!