See the attached
I think the formula you are looking for is [User used freight] / window_sum([User used freight])
it is a table calculation that needs to be set up as shown in the box below
and will return
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.