ExcelBanter - Pivottable Qtr's

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Pivottable Qtr's (https://www.excelbanter.com/excel-programming/347094-pivottable-qtrs.html)

JohnB

Pivottable Qtr's

Hi all
I'm grouping data by Qtr's and by months on column headings. Qtr1 always
starts at the January, but I want to get Qtr1 to start in April ??

Help!

reagrds
johnb

Jim Thomlinson[_4_]

Pivottable Qtr's

Add a column into your source data to calculate the quarter. I don't think
you can change the grouping option for when quarters start.
--
HTH...

Jim Thomlinson

"johnb" wrote:

Hi all
I'm grouping data by Qtr's and by months on column headings. Qtr1 always
starts at the January, but I want to get Qtr1 to start in April ??

Help!

reagrds
johnb

All times are GMT +1. The time now is 04:43 PM.