Crystal Reports SQL

Message

                           Part ID
Date                   50019     50013     50012     50010     Total

11/5/2006            3             5              14          1         23                             

12/27/2006          7             4               6           5         22

2/13/2007            9             7              7           12        35

3/7/2007              2            5              15           7          29

4/15/2007            6            9              11          12         38

total                     27          30            53          37        147 

hi all ,

i would like to create a sql statement to get the data high lighted in blue... which is the number of part id needed per day... i achived this data through cross tab, but now i need to use this data in groupin ....

can any one help me in this 
thanks