percentage in crosstab queries

[sk88]

I have multiple columns in my crosstab queries. Currently, they all display in count. How do I get them to display in percentage?



Thanks in advance

[rpeare]

percentage of what? the row the item is on? the column the item is on? the sum of the entire matrix?

[sk88]

percentage of what? the row the item is on? the column the item is on? the sum of the entire matrix?

Thanks rpeare.

I did a sketch of what I have in access database and what I would like to see.
The percent is of the row but it's tricky as I have two calculation going on. Please see attached image. Let me know what you think.

[rpeare]

can you provide a sample database so I don't have to create garbage data from scratch to reproduce your results before going any further.