This content has been marked as final.
Show 5 replies

1. Re: Calculating percentage of sum of a subset against the total.
Bill Lyons Mar 11, 2015 1:12 PM (in response to Pranay Sahu)Like the attached?

Running percent of total.twbx 33.8 KB


2. Re: Calculating percentage of sum of a subset against the total.
Pranay Sahu Mar 11, 2015 10:59 PM (in response to Bill Lyons)Thanks Bill for helping me out here. I think I was not clear previously.
I need to show only one number (percentage figure) not the percentage against all the states.
And the percentage value is the sum of top 10 sales value against all the sales value.
I hope I am much clear this time.

3. Re: Calculating percentage of sum of a subset against the total.
Bill Lyons Mar 12, 2015 8:50 AM (in response to Pranay Sahu)Like Sheet 2?

Running percent of total.twbx 34.9 KB


4. Re: Calculating percentage of sum of a subset against the total.
Pranay Sahu Mar 12, 2015 10:07 AM (in response to Bill Lyons)Thanks Bill..It's working..