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.