Alternate Solution for RANKCUMULATE Function

Options
riyazpasha
riyazpasha
edited April 24 in Academy Discussions

Hi All,

I have a solution using the Rankcumulate function but I want so avoid using it due to the performance issues. So I would like to know if there can be an alternante solution using other function

Logic :

  1. First I'm ranking the Sales data
  2. Weighted distribution is calculated for ex: 95/3220 = 3%
  3. Cumulate distribution is where I'm using the RANKCUMULATE(Weighted distribution, Final Sort)
  4. Sort is happening basis on the Prod seg line item, there is a sequence first iconic, Flag, A, B segment in this particluar order then cumulate distribution needs to be calculate.
  5. If there is not Prod seg assigned then cumulate distribution calulation should be from the highest sales corresponding weighted distribution to lowest.
  6. If ther are 2 same prod segment assigned then the cumulate distribution calulation should be from the highest sales corresponding weighted distribution to lowest

I have attached the secreenshot for the reference

image.png
image.png

Regards,

Riyaz Pasha

Tagged:

Categories