Forum Discussion
Customer Categorization based on Revenue
Updated considering all revenues (No time consideration) https://we.tl/t-IKDAi3F5OP
The gaps are normal when considering a specific time period as some customers did not buy during that period and hence they have no categorization. Usually we do the categorization per year same as we did for location so you will have the categorization per location per year. Regarding Category C, again this is a special case that will most probably disappear once applied to the full data set. Please do apply to the full data set and let me know of the issue persists.
Hi tamerj1
I noticed that there is some issue in categorisation, and it is flip-flopping from Category 2 to Category 4 and then back again to Category 2 among parent customers when invoice revenue is in decreasing order as shown in below screenshot for Per Location category
Same for Global Category
Also, for full data set I am also facing same issue..