Nov 20, 2002 #1 simma Programmer Sep 11, 2001 398 US Hello I have recordet like this monthyear countportfolio sumamount Nov99 123 345000 dec99 200 500000 Jan00 150 650000 How do i achieve format like this in crystal Nov99 Dec 99 Jan00 countportfolio 123 200 150 sumamount 345000 50000 650000 Thanks
Hello I have recordet like this monthyear countportfolio sumamount Nov99 123 345000 dec99 200 500000 Jan00 150 650000 How do i achieve format like this in crystal Nov99 Dec 99 Jan00 countportfolio 123 200 150 sumamount 345000 50000 650000 Thanks
Nov 20, 2002 #2 synapsevampire Programmer Mar 23, 2002 20,180 US Insert a crosstab, where: Column header: monthyear row headers: countportfolio sumamount Detail: countportfolio sumamount Should look about right. -k http://www.informeddatadecisions.comkai@informeddatadecisions.com Upvote 0 Downvote
Insert a crosstab, where: Column header: monthyear row headers: countportfolio sumamount Detail: countportfolio sumamount Should look about right. -k http://www.informeddatadecisions.comkai@informeddatadecisions.com
Nov 20, 2002 Thread starter #3 simma Programmer Sep 11, 2001 398 US Thanks synapsevampire! Do you mean summarised when you mentioned 'Detail'... Thanks Upvote 0 Downvote