dates in PT

M

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.
J

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
 
You must log in or register to reply here.

Similar threads

C
  • Question
Formula Based on Result of Drop Down Box
Replies
0
Views
81
Chris Waller
C
N
  • Question
Loop through pivot fields and add them as data fields based on if conditions
Replies
0
Views
118
n8n
N
J
  • Question
Absolute Week in a Month
Replies
3
Views
128
Joe4
Joe4
K
  • Solved
Row Condition Based on Dates In Three Columns
Replies
7
Views
265
Fluff
Fluff
P
  • Question
Dates in filter dropdowns
Replies
1
Views
148
jasonb75
J

Watch MrExcel Video

Learn Excel - Place People on Bell Curve - Podcast 2217

Forum statistics

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

Share this page

Top