I have a long list of 400 values that I need to assign into 5 bucket groups (1-5) based on value’s the percent of total. I have tried creating bins, but it has been tricky due to the dynamic values changing on a daily basis.

The calculation below was originally done in excel (sales rank is the column calculation wanted for tableau).
enter image description here

Before I tried to use rank functions and binning, but those did not work due to the column’s values being dynamic. Thanks for any help!