Sum by various properties

scambigol

Board Regular
Joined
Feb 20, 2003
Messages
77
I have a list of costs - for each one I indicate a time period, a region, and a person
I'd like to create a report that, on the same page, gives me the totals grouped by time period, then totals grouped by region, then grouped by person
how do I do that? I'd know how to make 3 separate reports, but I'd like to have them all in one (so they can be all in one page)

thanks in advance
gip
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Normally Access would group those inside each other, but I don't think that's what you want. By the sound of it, you need to build a few reports and turn them into sub-reports inside one main one. Probably easier to do than describe, but do a search on subreports and see what you find.

Denis
 
Upvote 0

Forum statistics

Threads
1,221,787
Messages
6,161,960
Members
451,734
Latest member
Anmol Pandey19

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top