Percentages across Categories

  • Thread starter Thread starter Jimmy G.
  • Start date Start date
J

Jimmy G.

I am writing a report in which I want to display the percentages displayed
within a category to reflect only the values in that category and not across
all the categories. For example, I've created a table that has the dollars
that come in from various regions and the number of individuals who gave
those dollars. Hence, one category is dollars and the other is donors. Since
the denominator represents the sum of all values in a column and the column
includes both dollars and donors, the percentages within the donor category
are insignificant since the denominator is so large. Is there a way I can
have the percentage reflects just the column values within the category and
not the entire column without having to write a subreport? Any suggestions
would be appreciated.
 
and the column includes both dollars and donors,
I did not follow this. Maybe if you posted some data with field name I
could figure it out.
 
For example,
2009 2008
Dollars

Asia $ 18,222 $9,298
2% .5%
Australia $ 325 $4,485
.1% .25%
.....
Sum $871,792 $2,501,846
100% 100%


2009 2008
Donors

Asia 16 27
1% .5%
Australia 2 5
.1% .1%
.....
Sum 1,254 2,649
100% 100%

I hope this makes sense.
 
The data you posted looks like some kind of spreadsheet.
What are your field names and datatype?
 
Back
Top