5 Replies Latest reply on Mar 12, 2015 10:12 AM by Tableau kumar

# Calculating percentage of sum of a subset against the total.

I need to calculate the percentage of sum of top 10 values against the total sales value across all the regions((e.g.(sum of sales value in top 10 region/sum of sales value of all 30 regions)) and the calculation changes with the quarter in filter.

• ###### 1. Re: Calculating percentage of sum of a subset against the total.

Like the attached?

• ###### 2. Re: Calculating percentage of sum of a subset against the total.

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.

Like Sheet 2?

• ###### 4. Re: Calculating percentage of sum of a subset against the total.

Thanks Bill..It's working..