Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

percent of total value in reports

jimbophobejimbophobe Member Posts: 7
Hi, i'm trying get the percent of each detail (or sum of subsection) for the total report.

example: i have a report that shows how much total was paid by cash or credit card. next to that value, i want to see that percent of the total amount paid.

table:
Type......Amount
Cash......70
Cred......130

i want to see
Cash......70.....35%
Cred......130....65%

is there a way to do this with a join (using that same table/query)?
or how would i do this?

thanks,

jim
Sign In or Register to comment.