display sub totals for each Agency and grand total

**excelrequired** · 02-08-2020, 08:55 PM

Hello

How do I display subtotals for each agency and the grand total? Is it pivot table or group by function, please help! attaching file.

**jeffreybrown** · 02-08-2020, 09:11 PM

Here's an example of both. Either could work for you, but your decision on how you would like to display the data.

**excelrequired** · 02-08-2020, 09:20 PM

Originally Posted by jeffreybrown

Here's an example of both. Either could work for you, but your decision on how you would like to display the data.

Thank You Jeff! Can you write down steps of how you did that. I need to do learn on how to do it, please and thank you!

**jeffreybrown** · 02-08-2020, 09:29 PM

For which one, Subtotals or the Pivot table?

**excelrequired** · 02-08-2020, 09:31 PM

Originally Posted by jeffreybrown

For which one, Subtotals or the Pivot table?

Both would be great. But if I have to choose one, Pivot table please

**jeffreybrown** · 02-08-2020, 09:32 PM

Subtotals >> https://www.contextures.com/exceldatasubtotals.html

Pivot Table >> https://www.contextures.com/CreatePivotTable.html

You are very welcome and thanks for the feedback/rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Re: display sub totals for each Agency and grand total