Sorting Issue in Pivot Table

[SDBoca]

I created a custom sort order to handle text values: 7AM, 8AM, 9AM, 10 AM, 11 AM, 12 PM, 1PM, etc. These are text values in the data list that I create with this formula (assume G2 as 7:08 AM) = Text(G2, "H AM/PM") which results in 7 AM as text. I thenk create a pivot table to list entries for each teller by hour. The labels show up as 7 AM,... 11 AM, 1 PM, 2 PM, 12 PM. How do I get the 12 PM to appear after 11 AM? I found a post that said it will be in the order as the data source if I do not set the pivot field options. See below. In Excel 2010, where do I find the pivot field options for PivotField.IsAutoSort?

Thanks,

Sharon



Please simply create the pivot table directly, the order of the pivot items will be same as the data source if you do not set the pivot field options i.e.., PivotField.IsAutoSort, PivotField,IsAscendSort