Cross Tab calculation in Individual column-Crystal Report
I am preparing a report in Crystal report 2008. Report template is Cross Tab.
Structure of report is
Cardname-Row, DocType-Columnd, DocTotal-Summarize field.
Result of this report is
IN(Invoice) RC(Incoming Payment) Total
XYZ 1000 -500 500
ABC 2000 -1000 1000
Total 3000 -1500 1500
I have inserted a column using calculated member. I want to Calculate in that column with BP opening balance
eg. OCRD.Balance-DocTotal when I do this it give first value to all column rows, i.e (consider XYZ opng Balance is 1500, I have calculate month opening balance which meance Current Opening Balance-Current month Order bookings=Month opening balance)
IN(Invoice) RC(Inc Pmt) Total Opng Balance
XYZ 1000 -500 500 500
ABC 2000 -1000 1000 500
Total 3000 -1500 1500 500
I want to calculate Opng Balance for each CardName but it gives first Customers opning balance to all customers.
Give me solution.
Thanks in Advance