I need to build a BI query (BI 7.0) as follows
Material Customer Period/ order qty Total %Total
No. No. 01/2011 02/2011 03/2011 04/2011 EA %
00001 AAAA 10 15 15 20 60 30
00001 BBBB 20 15 25 30 90 45
00001 CCCC 05 10 15 20 50 25
00001 Total 35 40 55 70 200 100
Can anyone suggest how to do this? has anyone done something simiilar? Any help is appreciated
Thanks
DV