Calculated field for Total% & Cumulative% with total column

I want to create a calculated fields for the total% and cumulative% using the total column for all the products.

Could someone help me with the formula to have the fields created as shown in the example with the percentage precision to 2 digits.

Here is the function you can use to calculate the percent of the total

Also, take a look at the blog below for performing cumulative functions.

Hope this helps. if you looking for something different. let us know.

1 Like

Hi [sakkamzn],
Thank you for your response. But, I might have missed to explain that the total is not a direct numeric field. Total is a distinct count of a string. So iā€™m unable to use percentofTotal & comparative calculations.

Hi @Sri

What is your dataset? Is it possible for you to handle this at the dataset level?