4 Replies Latest reply on Nov 15, 2018 5:09 PM by Ahmad Naim Ahmad Rosdi

    Add category to existing category.

    Ahmad Naim Ahmad Rosdi

      Hi, I dont know how to frame my question. Basically I want my data to display like the output below. In the database each product has its own category. Im trying to get total transaction including ar and charges. For charges I've used lod to get the amount. I have problem combing ar amount, charges amount into the category table.

       

      Data:

       

      transactionheaderdetailresource
      invoicetypeinvoice amountinvoicecharges 1charges 2charges 3charges 4charges 5charges 6invoiceresource noamountproductcategory
      inv1invoice900inv1-50-500000inv1250100prod250category1
      inv1invoice900inv1-50-500000inv1251200prod251category2
      inv1invoice900inv1-50-500000inv1252300prod252category3
      inv1invoice900inv1-50-500000inv1253400prod253category4
      ar1ar500

       

      Output

       

      categorytotal
      category1100
      category2200
      category3300
      category4400
      charges-100
      ar500