I need to calculate SUM(BSET-H2BAS) for different tax codes (BSET-MWSKZ)
BSET-MWSKZ will have T0,T1,T2,T3,T4 tax codes.
I need to display report as SUM(BSET-H2BAS) for T0,T1 in first column, and
SUM(BSET-H2BAS) for T2,T3 in second column and SUM(BSET-H2BAS) for T0,T4
in third column and SUM(H2BAS) for just T4 in 4th column,
do i need to use collect here?
Can you please help me how to do this?
Thanks in advance.
Edited by: Thanvi maraka on Jan 8, 2008 8:48 PM