exp vg
asked on
Access - Grand Total Column in Crosstab Query
Please offer if there is a way for me to include a Grand Total for the column field in a crosstab quert - Access 2013.
I am able to calculate totals (based on counts) for rows, but not columns.
Thank you.
I am able to calculate totals (based on counts) for rows, but not columns.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is also from Design View please. Thanks.
Yes, that is from the query grid.
if you provide some sample data, I could set it up for you.
if you provide some sample data, I could set it up for you.
ASKER
The step you offered I can do. Please let me clarify - this will create a separate totals column across the row, but how can I add a separate Grand Total row at the bottom of all rows in the query?
Hope this makes sense.
Hope this makes sense.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
If you want it as a query then probably you want to create another query that uses crosstab as its source and manipulate it accordingly.