I have problem in the attached file. Please help ASAP.

[Sokkorn]

Hi All,

Please take your value time to help me a little bit in the attached file. I really need it ASAP.

Thanks in advanced!

Regards,

Sokkorn

[#2]

I got ur problem can yousend me your excel

thanks

Meher

[#3 · Accepted solution]

One possible solution:  Use CROSSTABLE to create a variation of your data table, then add a column to indicate 'Debit' or 'Credit', then rework the Pivot table accordingly.  See load script below, and see attached QVW.

[TrialBalance]:

LOAD * INLINE
[AccID,           PER01,     PER02,     PER03
111-10-10-10,     0,          0,          -2809
111-10-10-20,     0,          -1154,     25
111-20-10-10,     2800,     2800,     1500
111-30-10-10,     -1000,     1000,     2300
112-10-10-10,     1000,     1500,     2700
112-10-10-20,     0,          1390,     570
112-11-10-10,     3698,     2000,     0];

TrialBalance_Temp:
CrossTable( Period, DCValue )
Load *
resident TrialBalance;

TrialBalance_DC:
Load
IF( DCValue >= 0, 'Debit', 'Credit' ) As DC,
*
resident TrialBalance_Temp;

drop table TrialBalance_Temp;
drop table TrialBalance;

[Sokkorn]

Hi DHutchins,

Thanks for your script. It correct one that I need.

Many thanks for your support.

Regards,

Sokkorn

[Sokkorn]

Hi Merwan,

The data that I load is not from excel file.