3 Replies Latest reply on Nov 16, 2015 1:08 AM by Christina Phillips

    Holding on to a value

    Christina Phillips

      Hi everyone,

       

      Private data I am afraid so hopefully I can explain well enough.

       

      I have a value for delivered goods which occurs when a field has a certain setting.  I am using this field in many viz's by using

       

            IF transaction = XXX then

                SUM(quantity)

           END

       

      I have done this for a few fields since they represent different transactions.  The data set is spread over time so when one of these values occurs it only occurs on that date.

       

      What I want to achieve is a calculation which lets me combine the running sum of two of these calculated fields.  Is there any way this can be done?

       

      I am able to graph the two running sums and this is good but I cannot do a calculation of one minus the other.  What I need to do is to hold onto the total value of each of them as I move along the table.  Can this be done?  In a prog language I would use a variable to hold the values then just minus one from the other at each point in time but Tableau is not really a programming language.

       

      Thanks in advance