How to Sort Column Field in Pivot table

G

Gali

Hello,

I don't find how to sort my column field.
I've 3 values for my field : Manuf ; Proc ; Eng. Is it possible to sort it
for a given order.
I've tried with the SortOnScope property but it fails : no error, and the
sort doesn't work.

Here the used code:
MyField.SortOnScope = Array("Manuf", "Proc", "Eng")

I don't know if it is the right property (for what i want to do), and if I
use it correctly.
Can you give me some samples (if any ...)

Many Thanks in advance ....

GG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project Center-Autolink column fields 0
Dealing with a Pivot Table (when I don't want to) 0
Pivot table drill down sort 0
list or combo box 0
Need help modifying code 0
Sort in VB using a ComboBox Column Other than the Bound Column 4
Sorting the pivot table field list 4
Sorting a Pivot Table Column that is not the first column... 0

Top