5 Replies Latest reply: Aug 25, 2011 2:06 AM by Sokkorn Cheav RSS

    Trial Balance Report - How to add sub-column in Pivot Table?

    Sokkorn Cheav

      Hi All,

       

      Currently I try to generate Trial Balance report. And my problem is on format the report.

       

      1. Here is the pivot table format in QlikView:

      AccIDPER01PER02PER03
      111-10-10-10$0.00$0.00($2,809.00)
      111-10-10-20$0.00($1,154.00)$25.00
      111-20-10-10$2,800.00$2,800.00$1,500.00
      111-30-10-10($1,000.00)$1,000.00$2,300.00
      112-10-10-10$1,000.00$1,500.00$2,700.00
      112-10-10-20$0.00$1,390.00$570.00
      112-11-10-10$3,698.00$2,000.00$0.00


      2. The format that I need is add Debit/Credit column in each column PER01,PER02,PER03

      (If amount>0 then we put it in Debit column and if amount<0 then we put in Credit column)

      AccIDPER01PER02PER03
      DebitCreditDebitCreditDebitCredit
      111-10-10-10$0.00$0.00$0.00$2,809.00
      111-10-10-20$0.00$0.00$1,154.00$25.00
      111-20-10-10$2,800.00$2,800.00$1,500.00
      111-30-10-10$0.00$1,000.00$1,000.00$2,300.00
      112-10-10-10$1,000.00$1,500.00$2,700.00
      112-10-10-20$0.00$1,390.00$570.00
      112-11-10-10$3,698.00$2,000.00$0.00


      How can I add column Debit/Credit in QlikView like format(2)?

       

      Please help to check and modify in the attached file.

       

      Regards,

      Sokkorn Cheav