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



      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