OWC Pivot table filter ordering

[Guest]

Hello

I hava an OWC Pivot Table component in an aspx file. I am using VBScript to
set properties when the page is loaded. I am setting the order of a field
using the OrderedMembers property which works great.

The problem is the drop down filter box of the field is not ordered as the
field is but appears alphabetically. Does anybody out there know how to order
the fields in the filter drop down box?

Thanks in anticipation

R