| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table grouping fields by Dept
I have a pivot table set up with several Depts and the 2008 Actual, 2008
Budget and % Variance to Budget (calculated field). My pivot is showing all the actuals by column for each department and then all the budgets columns by dept and then the % Variance columns. Ex: Acutals...........................Budgets......... ..........Variance................. Dept A, Dept B, Dept C, Dept A, Dept B, Dept C, Dept A, Dept B, Dept C How do I change it so that for each Dept it has Actual, Budget and % Variance columns all next to each other and then do the same for the next Dept? Dept A Dept B Act, Bud, Variance Act, Bud, Var etc. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table grouping fields by Dept
In the Column Area, drag the Dept heading to the left of the Data heading.
Terri B wrote: I have a pivot table set up with several Depts and the 2008 Actual, 2008 Budget and % Variance to Budget (calculated field). My pivot is showing all the actuals by column for each department and then all the budgets columns by dept and then the % Variance columns. Ex: Acutals...........................Budgets......... ..........Variance................. Dept A, Dept B, Dept C, Dept A, Dept B, Dept C, Dept A, Dept B, Dept C How do I change it so that for each Dept it has Actual, Budget and % Variance columns all next to each other and then do the same for the next Dept? Dept A Dept B Act, Bud, Variance Act, Bud, Var etc. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| Grouping Date Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| Grouping Data fields in Pivot Tables. | Excel Discussion (Misc queries) | |||
| Find name in list and get dept # enter dept # on work sheet | Excel Worksheet Functions | |||
| Pivot table grouping of dates in row fields will not work. Why? | Excel Worksheet Functions | |||
Linear Mode
