Hi ...

I'm trying to sort alphabetically a Pivot Table Report using the 2nd row field.
Unless I move the field to the first position, it does not get sorted alphabetically.
e.g.
Ist Row field - ID
2nd Row Field - Name
Currently it gets sorted in ascending order by ID. I need to sort by the Name in ascending order instead.
Appreciate if anyone has any idea how this can be achieved.