1 Reply Latest reply on May 11, 2018 3:27 PM by Okechukwu Ossai

    How to start a calculation with a "initial value from a datasource", and then using the "last calculation"?

    Jose Salazar

      Hi,

       

      I'm trying to create something like a "MRP" table. The picture below shows (sort of) what I want to obtain.

       

      My question is, how could I perform a calculation on which, the first result uses a "fixed value" from a datasource, and the rest of results use the "last result calculated"?

       

      Something like:

      Result_1 = Fixed_Value - m_1

      Result_2 = Result_1 - m_2

      Result_3 = Result_2 - m_3

       

      m's also come form the datasource and are date-dependent.

       

      Any help please?

       

      Tableau case.png