Hi Anton, You can use Axapta OLAP for that purpose. This requires MS Analysis Services SP3 installed.
Regards, Agus -----Original Message----- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 9:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table) Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch Item Amount ------ ----- ------- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 ----- ------- -------- ItemA 10 0 ItemB 10 10 can I do it in Axapta? thanks in advance, Sharing the knowledge on Axapta. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
