[Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)

2005-03-29 Thread Anton Tjiptadi 


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
-  --- 
ItemA   10   0 
ItemB   10  10

can I do it in Axapta?

thanks in advance,














 Yahoo! Groups Sponsor ~-- 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/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/

RE: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)

2005-03-29 Thread Agus Riyadi 

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  ItemAmount
--   -  ---
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/