I would like to group a date field in a pivot table manually. So, i want to choose, say, May12-Jun05, Jun06-Jun17, Jun18-Jul03...etc. In other words, not "evenly". So, say i select a few dates, and then right click, and select "Group". But, the dialog that comes up is for grouping by a range "how many days to group by". So, it seems not to allow me to manually select each group individually by an uneven number of days. So, i am wondering if anybody knows if there is any way to accomplish this.
Thanks,
Tom
Thanks,
Tom