1 Reply Latest reply on Mar 9, 2012 10:16 AM by Naisan .

    (percent from) of a (running total)

      I have a table created from some dataset in tableau that looks like the below table.

       


      date_activation_to_transactiondate_activation_to_transactiondate_activation_to_transactiondate_activation_to_transactiondate_activation_to_transactiondate_activation_to_transaction
      Activation MonthActivation01234
      March 20112500750650550450400
      April 20113000800750700650
      May 20113500700650600

      June 20114000800700


      July 201145001000



       

      I need to get the average sum from each column to the first.

      (The caviate is that the rows that have no value in them the same row needs to be ignored from the activation column to find the value for that column)

       

      Example:

      date_activation_to_transaction = 2

      SUM(550, 700, 600) / SUM(2500, 3000, 3500)

       

      date_activation_to_transaction = 3

      SUM(450, 650) / SUM(2500, 3000)

       

       

      At the end I should end with a table like this

       

      0

      1

      2

      3

      4

      23.14%

      21.15%

      20.56%

      20.00%

      16.00%