Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivottable : repeat break value
How can I repeat a break value in a pivottable. I have the following table : Year Month Value 2001 Jan 1000 Feb 2000 Mar 1500 2002 Jan 890 Feb 1780 What I need is this Year Month Value 2001 Jan 1000 2001 Feb 2000 2001 Mar 1500 2002 Jan 890 2002 Feb 1780 I can't find anything in the field settings or the table layout options. -- pehuyghe ------------------------------------------------------------------------ pehuyghe's Profile: http://www.excelforum.com/member.php...o&userid=27998 View this thread: http://www.excelforum.com/showthread...hreadid=474996 |
#2
|
|||
|
|||
Maybe you can convert the pivottable to values (just copy|paste special|values)
or even copy to a new worksheet (as values). Then since it's just data (not a pivottable), you can use some of the techniques at Debra Dalgleish's site: http://contextures.com/xlDataEntry02.html (But if you leave it as a pivottable, you won't be able to do what you want.) pehuyghe wrote: How can I repeat a break value in a pivottable. I have the following table : Year Month Value 2001 Jan 1000 Feb 2000 Mar 1500 2002 Jan 890 Feb 1780 What I need is this Year Month Value 2001 Jan 1000 2001 Feb 2000 2001 Mar 1500 2002 Jan 890 2002 Feb 1780 I can't find anything in the field settings or the table layout options. -- pehuyghe ------------------------------------------------------------------------ pehuyghe's Profile: http://www.excelforum.com/member.php...o&userid=27998 View this thread: http://www.excelforum.com/showthread...hreadid=474996 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
How to make repeat long numbers shortcut ? | Excel Worksheet Functions | |||
Sorting in PivotTable | Excel Discussion (Misc queries) | |||
Can't delete a page break | Excel Discussion (Misc queries) | |||
content does not stay in page break | Excel Worksheet Functions |