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.
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.