Pivot table grouping dates

[jilljhop]

Hello if I group data on a pivot table ie a Monday for 7 days do you need to put an end date of a Sunday or will it just fill up to the end of the table data?

 

[James006]

Hi,

For a complete and clear explanation, follow Debra Dalgleigh

How to Group Excel Pivot Table Data Fix Problems

Group Excel pivot table dates, numbers, text. Fix date grouping problems, cannot group that selection, extra dates. Videos, written steps, Excel file

www.contextures.com