Yeah, obviously they are different columns, but what I'm trying to ask is whether they have the same values or not... because it is illogical to get the percentage of an amount with respect to a sum of another set of amounts. You might get a total of 100% of all your calculated percentages but most probably you'll get > or < 100%.

Well, correct me if I'm wrong..

You could consider doing it like this way:

= (Clicks * 100) / Sum(Clicks)

OR

= (Clicks_Show * 100) / Sum(Clicks_Show)

No they Don't Have Same Values.. They Are Different..

Just Check Here..

*Clicks* Values : 9000, 8000, 10000

*Clicks_Show* Values : 8000, 6500, 11000

The Percentages I'm getting : 35.29%, 31.37%, 39.22%

The Total of these Percentages are

**>100**.. But I want to show Total Calculation for 100%..