Stripping time in Pivot Table Column Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My raw data, which I am pulling from a dynamic source, has a date stamp in
DD/MM/YYY : HH:MM format. I want to use the date field as a column header
and the primary sorting string.

Since the HH:MM is included, tho, it sorts down to the entire detail. I
cannot change or formate the source information; is there any way to do like
a TRUNC function on the column header? I can make a caculated field that
displays the information correctly, but it will not allow me to use that as a
primary comumn header.

Suggestions?
 
In the pivot table, right-click on the Date field button
Choose Group and Show Detail> Group
Select to group by Days
Click OK
 
I can make it sort by the date field as is with no problem, this issue is it
creates a header for each field since they are not unique; the first section
is 05/16/05 08:39 and the second is 05/16/05 08:42. I can't seem to get rid
of the time.
 
I suggested Grouping, not sorting. If you group by Day, you should see
one heading for each date.
 
Back
Top