I need Max data in one separate column and in-front of my past data.

[krishna_p]

Hi All,

   I need Max data in one separate column and in-front of my past data.

I have taken as sample but there are more then 10 lakhs data present.

I need max data of CD column and which is mentioned in CD column.

you can refer this image also.

please help me out whether this will working or not and if this will working then what is the best solution.

[sidhiq91]

@krishna_p  As per my understanding you wanted the Max of CD column based on the Sum(Sales).

So based on my understanding you can use the Firstsortedvalue() to resolve this issue.

Firstsortedvalue(CD, -sum(Sales))

This should resolve the issue, else please let me know if you need any other help.

[krishna_p]

@sidhiq91   This is not worked. but we have done from our side. Thanks for reply.

[krishna_p]

@locori This is not worked. but we have done from our side. Thanks for reply.

[krishna_p]

More info refer this SS.

Problem is In CD column last customer is vinit and In CD New column value vinit is given. I need like CD New column.

max(CD)    --- vinit

I need vinit value fill in one single column.