RE: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)
-Village] SQL Statement (crosstable / pivot table) Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result
[Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)
Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - ---