dates in PT

meir_to

New Member
Joined
Sep 7, 2002
Messages
4
how do I group dates (ex. from 2nd to 8th)
The pivot table has a dropdown with every days date to choose from.So its either
day by day or all.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

jimboy

Well-known Member
Joined
Apr 11, 2002
Messages
2,314
Right mouse over the field and select;

group and outline > group

hope this helps
 

Watch MrExcel Video

Forum statistics

Threads
1,118,670
Messages
5,573,569
Members
412,537
Latest member
Mohamed_5966
Top