I have a use case where I assign classes to IDs (Class 1 to Class 5) based on sum of sales as follows:
Class 1- Sum > Rs. 10,00,000
Class 2- Rs. 10,00,000 <= Sum < Rs. 1,00,000
Class 3- Rs. 1,00,000 <= Sum < Rs. 10,000
Class 4- Rs. 10,000 <= Sum < 0
Class 5- Sum= Rs. 0 or NULL
This analysis is done on a monthly basis. Most of the IDs remain in a single class all throughout the year. But, for some IDs, the sum varies drastically thus changing its class.
I want to display the ID when it changes from one class to another. How do I do this?
2 answers
Hi @Siddhesh Menon​, seems you might need a lookup or previous value function. Can you share a sample workbook?
