Sort by Date in Pivot Table Is not working

[Anonymous]

Hello!

I'm trying to sort  in ascending by [Base Material] , then  by PDD fields but for some reasons the PDD field failed to sort out.  I tried checking  the Text in sort tab and numeric value to no avail.  I also tried using the expression date(PDD) but  still doesnt sort right.

Pls help...

Tks.

[ecolomer · Accepted solution]

Try to put in the second field (Sales Order) your classification by Expression = PDD

[Anonymous]

Thank You, Enrique...It worked...I've been stuck on this for days...Just wondering why I have to place the =PDD in sales order field and not in the PDD field ?

Tks.