Hi,

I have data want to sort using pivot table in vba, that is only sort
by a column, eg
1 2 3
a b c
a b d
c b e

if i want to use column to to sort it

b

a c
a d
c e

how to do it? from pivot table i only see in the detail parts must do
some calculation like sum....how to just simple to show the row
details?

Thanks,
Robert