Exception Aggregation and %CT
Greeting BEx Query Designer Gurus,
Does anybody know how I can get my desired results from the following data?
Period
Order#-Units-Work-Days-Weighted-Multiplier
Avg-Days
01/2008
1231
--
5
7
0.217391304
1.52173913
01/2008
4567
--
2
7
0.086956522
0.608695652
01/2008
4568
--
9
16
0.391304348
6.260869565
01/2008
7890
--
7
19
0.304347826
5.782608696
Result--
23
49
1
14.17391304
02/2008
4892
--
9
12
0.5625
6.75
02/2008
5752
--
7
8
0.4375
3.5
Result--
16
20
1
10.25
In the above data, I am only interested in the Results for the Period Drilldown only row and the Average Days column. So only the 01/2008 14.1739... and 02/2008 10.25
The Weighted Multiplier is %CT ( Percentage Share of Result ) Units / 100. The Avg Days = Work days * Weighted Multiplier.
Problem is, when I take the Order # out of the columns, the Weighted Multiplier is no longer percent share of the Result, as the Result is now the total based on the Period.
I tried to make the Weighted Multiplier with Exception Aggregation Total, with Ref. Char = Order #, still no luck.
Any Ideas will be greatly appreciated....
Kind Regards,
Alex