Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pivot tables
Resolved · Low Priority · Version 2010
Reply Fri 16 Dec 2011, 13:38Delegate Phil said...
Phil has attended:
Excel Advanced course
Pivot tables
When you pivot a table of data for instance showing regional data on sales by Quarter for a number of products the pivot function can give you a regional breakdown by quarter by product on one sheet but with only a grand total. Can you get excel to automatically produce a total table broken down in the same way as the regional summaries, i.e. with products on the vertical and quarterly sales on the horizontal?
For upcoming training course dates see: Pricing & availability
RE: Pivot tables
Hi Phil, thanks for your query. That sounds like it should be possible but it's difficult to give you precise instructions without seeing your data. However, have a look at the following link on subtotals:
http://www.contextures.com/excel-pivot-table-subtotals.html#Show
Hope this helps,
Anthony
Wed 28 Dec 2011: Automatically marked as resolved.
|