Show Pivot Table Dates in a Month/Year Linear Fashion
in [General]
|
From: Marilyn on 12 Apr 2010 14:56 Hello, Is there a way to show dates in an Excel 2007 Pivot table in a Month/Year Linear fashion? Any help/suggestions will be greatly appreciated.
From: trip_to_tokyo on 12 Apr 2010 15:24 EXCEL 2007 Please refer to:- http://www.pierrefondes.com/ Item number 94. Any good for you? If my comments have helped please hit Yes. Thanks. "Marilyn" wrote: > Hello, > > Is there a way to show dates in an Excel 2007 Pivot table in a Month/Year > Linear fashion? > > Any help/suggestions will be greatly appreciated.
From: Roger Govier on 12 Apr 2010 18:26 Hi Drag Year to the Row area followed by Month to the Row area -- Regards Roger Govier trip_to_tokyo wrote: > EXCEL 2007 > > Please refer to:- > > http://www.pierrefondes.com/ > > Item number 94. > > Any good for you? > > If my comments have helped please hit Yes. > > Thanks. > > "Marilyn" wrote: > >> Hello, >> >> Is there a way to show dates in an Excel 2007 Pivot table in a Month/Year >> Linear fashion? >> >> Any help/suggestions will be greatly appreciated.
|
Pages: 1 Prev: AVERAGEIF FORMULA EXCEL 2007 Next: Convert FUMIFS to a format useable in Excel 2003 |