C
Chris Redekop
I have a field in my pivot table which contains a data range (ex. "Jan 1,
2004 - Jan 15, 2004") and I'm having trouble sorting it properly. The
default behavior is to sort it like a normal string, which if course isn't
good, February comes first etc. So I'm trying to define a custom sort
order. Currently I'm trying the only way I can find in the docs, and that's
setting the OrderedMembers to a properly sorted array of all the possible
values of that field, however I can't get this to work, it always still
displays in it's normal default order. The only difference I can find is
that there's another option in the context menu saying 'clear custom
ordering', however clearing it also makes no difference. Anyone have
experience with this or know of a doc I don't?....basically the only doc I'm
going off of is the OrderedMembers property page in the object model
reference, can't find anything else to do with custom sorting.
Is this the only way to achieve a custom sort?....it seems like a really
horribly inefficient way to do it. Is there perhaps a way to specify a
callback to compare 2 items? (like the way most other pieces of software do
it)....this would be alot more ideal. Like take for example I may need to
have a 'time of day' field, but the pivot table doesn't support a time type,
so in order to get it to sort properly I'd have to supply a list if 12:00am,
12:01am, 12:02am etc which would be terribly painful.
Any help is appreciated, thx
2004 - Jan 15, 2004") and I'm having trouble sorting it properly. The
default behavior is to sort it like a normal string, which if course isn't
good, February comes first etc. So I'm trying to define a custom sort
order. Currently I'm trying the only way I can find in the docs, and that's
setting the OrderedMembers to a properly sorted array of all the possible
values of that field, however I can't get this to work, it always still
displays in it's normal default order. The only difference I can find is
that there's another option in the context menu saying 'clear custom
ordering', however clearing it also makes no difference. Anyone have
experience with this or know of a doc I don't?....basically the only doc I'm
going off of is the OrderedMembers property page in the object model
reference, can't find anything else to do with custom sorting.
Is this the only way to achieve a custom sort?....it seems like a really
horribly inefficient way to do it. Is there perhaps a way to specify a
callback to compare 2 items? (like the way most other pieces of software do
it)....this would be alot more ideal. Like take for example I may need to
have a 'time of day' field, but the pivot table doesn't support a time type,
so in order to get it to sort properly I'd have to supply a list if 12:00am,
12:01am, 12:02am etc which would be terribly painful.
Any help is appreciated, thx