How to calculate cumulative ratio in quicksight

I have some ms_value for some products, I want to calculate a cumulative ratio for that in quicksight.

You can combine runningSum and sumOver.

Might look something like this.

This will take the running sum and grouped by client name and then divide it by the total amount.

runningSum(sum({int bearable}),[{client_id[users]} ASC])/sumOver(sum({int bearable}),)

1 Like

Hi @suresh1. Did Max’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!