3 Replies Latest reply on Aug 9, 2018 11:52 PM by lei.chen.0

    How can I find out Employee's First three month sales from their start date?

    Thiraj Silva

      Hello Friends,


      I am relatively new to Tableau and I have a requirement to find out the total sales for the first 3 months of the employees (almost 10,000 employees) starting from the start date.

      I have two tables, Employee and Transaction. Both tables have a common field (Employee ID).


      My requirement is employees join on different dates, so how can i calculate sales for each of them since their start date.


      All help is appreciated.

      Thank you



      * Cannot share data as it contains sensitive information.*