3 Replies Latest reply on Jan 11, 2019 8:11 AM by Jim Dehner

    Need Last three days Sum of Sales

    Amiya Basak

      Hi,

       

      I am creating a Tabular report with

      Order_Date, Segment, Category, SUM(Sales) , SUM(LAST 3 DAYS SALES)

       

      I am stuck to create   SUM(LAST 3 DAYS SALES) inTableau. I got same issue before but did not get any resolution. Can you please help me to get the answer.

       

       

      Here Date 8th Jan, 12th Jan is missing but last three days always go back three days back not by index last 3 records. If any previous one day missing then it will calculate last two days.

       

      Let me know if I could explain it or you need any further input.

       

      Thanks, Amiya