4 Replies Latest reply on Jul 20, 2017 10:29 AM by Jim Dehner

# Cummulative Ratio

I need to take a Cummulative Ratio of values as shown in this Excel sheet.

So, 640 is the Sum of metric1 for (0-10) range, 540 is the Sum of metric1 for (2-10) range..... I have attached the actual excel sheet and the twbx file.

• ###### 1. Re: Cummulative Ratio

Eva there are table calculations for your numerator and denominator

Numerator           WINDOW_sum(SUM([Metric1]), 0, 10)

Denominator          WINDOW_sum(SUM([Metric2]), 0, 10)

Then      Numerator/Denominator

and you get your chart I am on 10.3 so you would not be able to open a workbook

Let me know if this helps

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 3. Re: Cummulative Ratio

Thanks much Jim! It worked, I marked it as the 'Correct Answer'

• ###### 4. Re: Cummulative Ratio

Glad to help out

Thanks for the badges

Jim