subtotals and pivot tables

[whenweescape]

I am currently working on a project for school it is pretty basic excel. It is not that hard, but I having some issues with subtotals. Is there anyone willing to assist me on this project me. I am will to compensate if needed, just need some guidance. Please contact me directly and I will forward the project directions and excel attachment.


use subtotals to determine the total revenue in both November
and December by assets under management and channel of acquisition (i.e. you will report 12 values for
November and 12 values for December; e.g. total revenue in November 2012 for Under 100K customers
acquired via Email). [Hint: collapse the various levels of subtotals to view the data more easily]. Include the
results in your report and write a few sentences about your findings.

Thanks.

J

[Vaslo]

Is this what you are looking for?

Excel Subtotals.xlsx

[whenweescape]

Thanks! It is part of it, but I need it to show in the worksheet not a pivot table. Are you able to do something like that?

[Vaslo]

You could just cut and paste it over, if that's what you mean.