Item wise Purchase through NAV WebServices

Hello Friends,

I am developing a ASP.NET web Application using NAV webservices. I need to show Item wise sale for every month. for that i retrieve data from ILE with Entry Type=Sale filter. Now I want to show data in following manner -

Item No.| JAN | FEB | MAR | Apr | May | JUN |JUL | AUG

IT-0001 | 250 | 500 | 700 | 900 |

IT-0002 | 500 | 700 | 900 |…

How do i do this.

Plz give any suggestion or solution or help.

Thanks