Help required in getting the Contribution column based on RANK

[qlikviewforum]

Hi,

We have created the straight table as mentioned in the excel(till Sales column). Now we are stuck while creating the "Contribution" column(The formula is as mentioned in the excel). The expression of "Sales" is as mentioned in the txt file. Could you please help create the "Contribution" column?

I have put the comments in the txt file to understand the expression better. Please let me know if you have any questions.

Thanks in advance

[Kushal_Chawda]

You can take private help which is not a problem but better to post the sample here as you will get many options to handle your requirement

[swuehl]

Deleted posts on request of the OP.

(not sure why this should have shown any confidential data, though).