View Single Post
  #1   Report Post  
T1 Red Alarm
 
Posts: n/a
Default 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?