Skip to Content
0
Former Member
Jan 11, 2012 at 08:38 PM

BI query for Percent of totals for period range

43 Views

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