View Single Post
  #1   Report Post  
pehuyghe
 
Posts: n/a
Default 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