| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable Automatic Subtotals
I have a PivotTable with Customer, Date grouped by Year and Month. The
table has AutoFormat Report 6 applied. The Date group is set to show items with no data. This is important and must stay that way. I use the even spacing to create a static report with a difference line automatically added. There are some customers that do not have data for all listed years. So they may have information for 2004 but nothing in 2005. The table is displaying the grouping as such: Customer 123.00 2004 123.00 Jan 123.00 Feb 2005 Jan Feb The year that doesn't have any data is shifting the month up into the year row. How do I stop this from happening? Is there any way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| options to update automatic links | Excel Worksheet Functions | |||
| Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
| Sorting in PivotTable | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
Hybrid Mode
