Weightage Calculation

[#1]

Hi Guys,

I am struggling with this Calculcation..

I am trying to calculate the Weightage equation in Qlikview in the above diagram. Can anyone help me?

I tried the following equations

=Sum(Aggr(Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR])/Sum(TOTAl<DeliveryDocument_Key>Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]))* Range, DeliveryDocument_Key))

= (Sum(Total<DeliveryDocument_Key> DeliveryQuantity/[ST/KAR1]) * Sum(aggr((Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR])* Range),DeliveryDocument_Key)))/ (Sum(Total DeliveryQuantity/[ST/KAR1]))

could not get it correct. Can anyone help

I also need the Pivot Sum at the top correct which does not seem to be the case!

Regards

Sravan

[#2]

=Sum(Aggr(Sum(DeliveryQuantity/[ST/KAR1])/Sum(Total <DeliveryDocument_Key>(DeliveryQuantity/[ST/KAR1]))* sum(Aggr((Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]))* Range,DeliveryDocument_Key)),DeliveryDocument_Key))

Thought this is the Perfect answer. Still it does not work

[#3]

I thought of attaching a sample... here it is

Hope someone can help now!

Thanks in Advance

[#4]

Setanalysis experts..any help??

[#5]

I am not getting this done..Any Help is really appreciated!