Crosstab Query Wizard...Can percentages also be displayed?

C

Cheese

When using the Crosstab Query Wizard to count values, is it possible for
either the Query or Report (made from the query) to also display the
percentages that sum to the total column? Here's an example of what I'm
looking for:

TOTAL CATEGORY1 CATEGORY2
4 (100%) 3(75%) 1(25%)
 
K

KARL DEWEY

Yes. Edit the source of the value. If the currect source is Quality and
the Total is the Sum([Quality]) then use this in the grid --
[Quality] & " ( " & [Quanity]/Sum([Quanity])*100 & " )"
 
Top