Let@s make it clear : Date Amount Flag 01/01/97 100000 Income 01/02/97 200000 Payment 01/03/97 200000 Income 01/04/97 5000 Payment And I want crosstab like :
Date Income Payment 01/01/97 100000 01/02/97 200000 01/03/97 200000 01/04/97 5000 Without big numbers I get : Date Income Payment 01/01/97 100000 0 01/02/97 * 01/03/97 200000 0 01/04/97 *