10 Replies Latest reply on Apr 21, 2018 5:39 PM by Tony Fahd

    how to track year over year change

    Tony Fahd

      so i am attaching a workbook where i have list of my customers in 2017 and 2018. each customer has a category. some customers stayed in the same category in both 2017 and 2018, bust some customers change categories. so for example customer cda was in category A in 2017 and switched to category E in 2018. some customers didn't change category (customer ty)

       

      how can i track those changes. i want to find a way to be able to show how many of customers are making changes from A to E or any different categories. i want to be able to show percentages as well. something like 20% of my customers changed from A to B in 2018 and so on, and want to show new customers in 2018 (customer CDS)and customers who had a category in 2017 and no longer in 2018(customer io)

       

      any help is much appreciated.