Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
pivot table row vs column headings | Excel Worksheet Functions | |||
how do i subtotal an outer column in a pivot table? | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |