Stripping time in Pivot Table Column Header
 

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

T1 Red Alarm wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

"Debra Dalgleish" wrote:

In the pivot table, right-click on the Date field button
Choose Group and Show Detail Group
Select to group by Days
Click OK

T1 Red Alarm wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I suggested Grouping, not sorting. If you group by Day, you should see
one heading for each date.

T1 Red Alarm wrote:
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.

"Debra Dalgleish" wrote:


In the pivot table, right-click on the Date field button
Choose Group and Show Detail Group
Select to group by Days
Click OK

T1 Red Alarm wrote:

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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html