Crosstab Query with Percentages of Total

[McArthurGDM]

I am trying to build a crosstab query that gives percentages rather than counts or averages or other calculations. I'm not quite sure how to do this, though. Any help would be appreciated. Here is an example of the kind of crosstab query I am looking for.

	Jan	Feb	Mar	Apr
A	5%	80%	90%	100%
B	90%	10%	0%	0%
C	2.50%	5%	0%	0%
D	2.50%	0%	10%	0%

Thanks!

[June7]

I think percentages are easiest calculated in report where totals can be calculated in group or report footer and the group or detail sections can reference the aggregate controls. However, creating a report to run perpetually based on crosstab query is not easy. http://allenbrowne.com/ser-67.html

[McArthurGDM]

I see what you are saying about the controls referencing an aggregate number in the report. That makes sense.

I was a bit worried I couldn't create a graph of these percents, but you just need to go into Chart Types (in design mode) and select 100% view of the data.

Thanks!

[McArthurGDM]

I just ran into an issue with the graphing of these percentages. Yes, you can graph numbers as percentages of a total instead, BUT you can not display the percentages within the graphs - just the number values.

This means I may have to create a query that will produce those percentage numbers instead. No?

Thanks,

[June7]

That does sound correct. I've never done such a graph. Will require multiple queries.

First do an aggregate query that does the summation you want. Then join that query to table. Create a field that calcs percentage. Use that query as graph data source.