9 Replies Latest reply on Oct 21, 2013 7:30 AM by Dan Huff

    What formula will get me the answer

    Libitha Thinakaran

      I have my data in attached format with col1, 2 and 3. I have to derive Col 4 in tableau.

      For each day, we have sales metric but when day 2=day2 i have to take the corresponding value from col2 and populate across all rows in col4 in tableau.

       

      If function gives 100 only for second row but i need 100 to be populated for all rows

       

      Attached the packaged workbook also. I want 318 to be populated in all the rows instead of one row.