Using Column Totals in other columns' formulas
Posted on 2004-11-23
I have the following view:
Contributions (View name)
-Contributor Name (col 1)
-Number of Contributions (col 2)
-Percentage of Total Contribution (col 3)
Example Data may look like this:
Fred Lord, 10, ?
John Guy, 90, ?
How do I calculate the 3rd column such that it shows the respective percentage of contributions? (i.e. For Fred = 10% and for John = 90%)
I know how to use column totals (which shows the total number of contributions), but I don't know how to programatticaly get at that value in the column formula for "Percentage of Total Contribution". Any ideas?
I'm not sure which is the best way to go about getting at the percentage?
Any help would be appreciated. Thanks.