Trail Balance

[upaliwije]

Hi My Friends

I want your advice. I have created a trial balance in QV document in a Pivot table. But I can get the grad total of Debit and Credit Columns. Kindly see may attached QV doc and advise me pls

[Anil_Babu_Samineni]

Like this?

[rahulpawarb]

Hello Upali,

Have you tried Show Partial Sum option available on Presentation tab?

Regards!

Rahul

[upaliwije]

I have tried it

[upaliwije]

Yes like as you shown

[Anil_Babu_Samineni]

Why you want Pivot Table instead of Straight table. Change it to Straight table and then use Sum of rows radio button

[MK_QSL · Accepted solution]

May be because there are not groups between CODE and GL_DESCRIPTION. It's one to one..

Try Straight Table and use below expressions

SUM(Aggr(IF(SUM(DEBIT)-SUM(CREDIT)>0,SUM(DEBIT)-SUM(CREDIT),0),CODE,GL_DESCRIPTION))

and

SUM(Aggr(IF(SUM(CREDIT)-SUM(DEBIT)>0,SUM(CREDIT)-SUM(DEBIT),0),CODE,GL_DESCRIPTION))

[upaliwije]

Thanks  You answer also works . But Manish script works with Pivot table as well

[rahulpawarb]

refer

General Total Column in Pivot Table