Skip to main content

Hi. Tableau fans)

Some problems with chain index(

What i need? I create 2 parametrs -start year and end year. For example- start year is 1999, end year-2005. Result is 3.936787508 (1999 number)*2.686202359(2000 number)*.....1.103388795(2005 Number)/

How to do that?

4 answers
  1. Jun 30, 2018, 3:16 PM

    see the attached approach

    filter to limit the data range

    see the attached approachfilter to limit the data range Product of successive numbersreturns thisJimIf this posts assists in resolving the question, please mark it helpful or as the 'correct answer' i

     

    Product of successive numbers

    pastedImage_1.png

    returns this

    pastedImage_2.png

    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.

0/9000