6 Replies Latest reply on Aug 9, 2018 11:53 PM by Tausif Kazi

    Calculate Customer Sales % per year separately

    Tausif Kazi

      Hi Team,

       

      PFA the required sheet with requirements added into the same.

       

      I want to calculate the sales % per employee for different dates which are PY (Jan 2017 to Dec 2017) and PYTD (Jan 2018 to Jun 2018). (Dates can be dynamic in nature)

       

      I have 2 columns PY Sales and PYTD Sales which will have text values based on the calculated fields.

       

      Please see the data file. I have added formulas in the file and the required Output in the other sheet.

       

      Regards,

      Tausif.