3 Replies Latest reply on Dec 6, 2018 11:22 AM by Don Wise

    Taking the Product for Multiple Rows

    Elizabeth Ancin

      Hello,

      I am trying to calculate the product of an output for multiple rows:

      I want to take the product of 4 separate rows: so my equation in Tableau is :

      For the Column: Product

      if [System] = LOOKUP(ATTR([System]),-1)

      then SUM([Available]) * Previous_Value([Available])

      endif

      System
      Available
      Product
      Cable22

      Cable

      3ex. (2*3)
      Cable1ex. (2*3*1)
      Cable5ex. (2*3*1*5)
      Connector2
      Connector1
      Connector4

      And continue this process throughout, however I have tried many different though processes and cant seem to have this work.  Is it possible to take the product of multiple rows and output it into another column?

      Any help would be much appreciated.

      Thank you,

      Elizabeth