Pivot Tables - Sort Data

[Santy28]

Hi,

I have a data which has a Project#, Project Approved Date, Project Budget$.... so on. When i do a pivot on the data by selecting Row labels as Project# and Project Approved Date and values as the sum of Project Budget$. The problem is when i sort the value fileds from largest to smallest i don't see any change but if i remove the Budget Approved date from row labels and do sorting it works.

Help me with this issue.

 

[Chihiro]

Without sample file hard to say. But I'm guessing one of the row label field has only single item per line.

PivotTable sorting is done in following order when there are more than single row label field.
Row Label Parent -> Row Label Children -> Value fields

Value fields are sorted within Row Label Children context. So, if Row Label Children has single item, value field sorting does not show.