6 Replies Latest reply on Feb 26, 2018 9:42 AM by Samanth Yadav

    Sales Calculation

    Samanth Yadav

      Hi All,

       

      I have employee sales data for each month where I have employee name, date and sales. I need help in sales calculation. For example: In Jan 2017, the sum of sales for employee Sam

      was $10,000 and in Feb 2017, the sum of sales was $20,000. So when I select the date filter for Feb 2017, I need to see the sum of sales for Jan 2017 and Feb 2017(i.e; $30,000). Similarly, when I select march I need to see the sum of sales for Jan, Feb and march (i.e; $60,000), so on till Dec 2017. But when I select  Feb 2018,  I should see the sum of sales for Jan 2018 and Feb 2018 (i.e; $290,000), Similarly for march 2018.

       

      Can someone help me out on this calculation.

       

      Attached is the Tableau Package Workbook.

       

      Regards,

      Sam

      Shinichiro Murakami