3 Replies Latest reply on Apr 3, 2018 6:53 PM by lei.chen.0

    Change report

    Nisha S

      Hi All,

       

      I have a requirement, needed your idea /sugestions .The first 4 tab’s are the data file namely Monday,Tuesday, Wednesday, Thursday.

      The requirement to create a report that should reflect the changes that happened over the four days for tier of employee, Number of customers and business segment.

      The way the business wants the result as follows. For reference, I used Emp ID 1 for an example. The employee’s (Emp ID 1) changed cell value should be color coded (whole background of cell to be red and text as white) to reflect the changed values. I have attached excel sheet that contains sample data for the reference.

      Note: The data source formatting should be as it is, i.e. don’t change the excel file structure .

       

      Thanks & Regards

      Nisha