Pivot Table Date Grouping

Jill (Australia) · May 19th, 2002, 11:46 PM

The reporting month here is 16th to 15th, rather than whole months.

Is there any way to get Excel to group by this period?

I have seen a Pivot Table which was set to group by fortnights, but can't remember how it was done.

Thanks,

Jill

anno · May 20th, 2002, 12:43 AM

jill
i think this will do what you need:
right click on the field name you want to change, select 'group and outline' then 'group' from the shortcut menu. put in start and end dates, select 'days' and set 'number of days' to 14.
anno

[ This Message was edited by: anno on 2002-05-19 23:53 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 19th, 2002, 11:46 PM	#1
Jill (Australia) New Member Join Date: May 2002 Posts: 3	The reporting month here is 16th to 15th, rather than whole months. Is there any way to get Excel to group by this period? I have seen a Pivot Table which was set to group by fortnights, but can't remember how it was done. Thanks, Jill

May 20th, 2002, 12:43 AM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	jill i think this will do what you need: right click on the field name you want to change, select 'group and outline' then 'group' from the shortcut menu. put in start and end dates, select 'days' and set 'number of days' to 14. anno [ This Message was edited by: anno on 2002-05-19 23:53 ]